sswcharlie
01-29-2021, 12:50 AM
Hi
Excel2016 Win7
Been searching for info on how to:
USB RFID readers (say up to 10) use HID to place tag numbers into Excel sheet say column A This works well.
All readers place tag number in column A
Readers all have same pid vid etc. No serial number, so all are all identical. Only differences are position of reader on USB hub.
Is it possible to have a vba pre enter event, to add a prefix or suffix to the tag number being entered. That is a different prefix for each reader on USB hub ?( Excel will then be used to place in each readers own column/sheet. This is no problem. just need the vba to identify which USB port is being used
So if reader AA sends number 1234 it adds a suffix and becomes 1234AA
and if readerBB sends number 6789 it adds suffix and becomes 6789BB etc etc
VBA will have to know which USB port data is coming from.
Thankyou
Charles Harris
Excel2016 Win7
Been searching for info on how to:
USB RFID readers (say up to 10) use HID to place tag numbers into Excel sheet say column A This works well.
All readers place tag number in column A
Readers all have same pid vid etc. No serial number, so all are all identical. Only differences are position of reader on USB hub.
Is it possible to have a vba pre enter event, to add a prefix or suffix to the tag number being entered. That is a different prefix for each reader on USB hub ?( Excel will then be used to place in each readers own column/sheet. This is no problem. just need the vba to identify which USB port is being used
So if reader AA sends number 1234 it adds a suffix and becomes 1234AA
and if readerBB sends number 6789 it adds suffix and becomes 6789BB etc etc
VBA will have to know which USB port data is coming from.
Thankyou
Charles Harris