I need assistance in importing via HID into Excel and showing the USB device source reference in the SS.


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

http://www.rfidshop.com/index.asp?fu...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. This is ok if I can tag each entry with the USB ID, and then tell Excel in which column to transfer each devices info is to go.



The device manager gives separate 'Device Instance ID' for each device eg:
USB\VID_1241&PID_E000\5&1DC3342F&0&2
USB\VID_1241&PID_E000\5&1E9A0CB1&0&2

How do I get Excel VBA to recognise the different Device ID and tag each each entry at the 'live cell' with the individual Device ID reference.


Charlie