Right, someone has bought a barcode scanner, with the hope that you can scan an object and show the relevant data in excel.
The scanner is connected via a keyboard wedge and as far as I can tell, all the scanner does, is read the barcode and output the data as if the keyboard were typing. As far as any software on the computer is concerned, there is no barcode scanner (if you know what I mean).
So I am guessing, the only way to achieve what I (read: they) want is designate a cell that will hold the scanned item code, and have a load of others that VLOOKUP the relevant data. Please correct me if you know of another way.
There is also talk of doing an Access lookup jobby. I am again guessing this will be just making sure a specific field on the form is highlighted before scanning.


LinkBack URL
About LinkBacks
Reply With Quote