Two Active Cells in Spreadsheet (or eqivalent) - as for games etc

[Charlie]

I need help :-


I have purchased a couple of these devices: (USB Pen Drive for Reading RFID
tags)

http://www.rfidshop.com/index.asp?function=DISPLAYPRODUCT&productid=1120

XP Home 97 Excel
I want to import info into Excel via the USB RFID reading device (via Human
Interface Device).

Using one device works fine and places info in Excel at the active cell.
Using two devices both readings go in same column again in the active cell.

However I want to be able to recognise indivdually 2 or more USB ports? and
then tell Excel in which column each devices info is to go.

How do I get to link and route each usb device?


I gather there are some excel games. Do any of these allow two people (2
controls) to play at once ?

How do they get two to work simultaneously ?

Charlie

 

[Nick Hodge]

Charlie

AFAIK there can only be one activecell in Excel, even if you select many,
only one is active

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[NickHK]

Charlie,
A quick look at that link does not show anything available to interface with
the device: It states "No software is required", so I imagine it simulates
keyboard input.
As such, there is not much you can do before the data is in a, say, an Excel
cell. Once you have the data, depending what is passed, you can then move
the value to a certain cell.
They say
"Output Format: Hex: B1 B2 B3 B4 B5 B1 to B5: 5 pairs HEX code equal to the
card 40 bits serial number."

does this get passed also, so you can determine which reader send the value
?

NickHK