USB port number

[Excelgreenhand]

I have connected two barcode scanners on the same computer, is it possible to know which one is the input device based on the USB port id or just depends simply on the prefix of the guns.
Any suggestions !? (VBA please if you could)

 

[Leith Ross]

Hello Excelgreenhand,

I am not clear on what information you want. Every barcode scanner is an input device connected to an port, either a COM or USB.

Do want to return the id of the scanner in use?

 

[Excelgreenhand]

Hello Leith,

Thanks for the prompt reply and interest.
I would like to get and identify which scanner's input and contents when writing in like into an Excel's sheet from the two continuous feeding and analyze the quantity scanned and the scanner's info.
Thank you again.

 

[Vishnu_k_madhu]

Hello Leith,

Thanks for the prompt reply and interest.
I would like to get and identify which scanner's input and contents when writing in like into an Excel's sheet from the two continuous feeding and analyze the quantity scanned and the scanner's info.
Thank you again.

For the same problem I am trying to find the solution. So if anyone know the solution means please respond.

 

[Excelgreenhand]

Hello, Happy New Year to All!
A big surprise to my original post and still someone is still interested to find out more.
I would like to keep it simple.
I have 2 scanners scanning the same piece of barcode to retrieve info from it, but first I have to find out who initiates the action.
Scanner I (from production) and Scanner II (from packing), here I would like to identify who it is and that is why I need to retrieve the USB id since I know which USB port I plug on the mobo.
ie. If Scanner I is plugged in the USB000001(production) and If Scanner II is plugged in the USB000002(packing) , I could do report what the action they do and credit that department.
Let me know if the above is clear, and awaiting for ALL your suggestion and advice. Info is stored into Excel sheet.
Again Happy New Excel year!

 

[Kyle123]

It'd be a lot easier if you just terminated each scan with a different character, you'd then only need to look at the last character of the scan to know where it had come from

 

[Excelgreenhand]

Thanks.
Good idea.
But how about I have 255 USB scanners attached to a single computer.
Good idea anyway, good start.

 

[mole999]

do you really have 255 scanners ?