how to link barcode scanner to special Excel

[hamed216]

hi

i have a big problem about linking barcode scanner to excel .

i link it . but when i use scanner , i cant use my PC . because when i use scanner ,and i open each kind of office , serial numbers went there .

now , how can i link barcode scanning to special excel ,worksheet and column . until when i use scanner , other operators can use this system without missing data of scanner.

thanks

 

[Pup Denab]

HI Hamed
Welcome to the forum, I've never heard of anybody trying to do this, however the simple answer would be, does the scanner you have,a memory chip, if so you could import to excel though a macro (every 15 minutes or so), if no, I'm not sure its possible, the reason is that the scanner will work like a keyboard, which gives you the exact same problem you are having, or just use any old PC or laptop with any version of office, to record your data & use the macro to import the data to your sheet.

 

[Pup Denab]

HI Hamed
This has been bothering me for a while now, so after a bit of searching their are commercial solutions. which will do what you ask, like the one below
Software - Computer Data Acquisition System w/ USB Cable - Control Company Model 4136

so it is possible,