J
Jase
I wish to use excel for inventory and would like to use a barcode scanner to
import serial numbers etc. Can you do this in excel?
import serial numbers etc. Can you do this in excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JoeUser
Hello,
Barcode scanner is just like a keyboard, so it should work in any
application which supports keyboard (accepts keyboard input). A customer of
mine asked me to test his barcode scanner, and I just tested the scanner in
Excel, Word, Notepad and Wordpad. Worked perfectly.
Best Regards
Barcode scanner is just like a keyboard, so it should work in any
application which supports keyboard (accepts keyboard input). A customer of
mine asked me to test his barcode scanner, and I just tested the scanner in
Excel, Word, Notepad and Wordpad. Worked perfectly.
Best Regards
J
Jase
Hey Joe,
Thanks for the reply.Sorry about the lameness of the question but how did
you test it within excel, how do you get the information into those various
applications?
Thanks for the reply.Sorry about the lameness of the question but how did
you test it within excel, how do you get the information into those various
applications?
J
JoeUser
Hello,
Just scanned some barcode. In Excel and all applications I tested, whatever
I scanned went to the active position of the cursor.
Best Regards
Just scanned some barcode. In Excel and all applications I tested, whatever
I scanned went to the active position of the cursor.
Best Regards
J
Jase
Thanks champ, I'll give it a whirl tomorrow!
JoeUser said:Hello,
Just scanned some barcode. In Excel and all applications I tested, whatever
I scanned went to the active position of the cursor.
Best Regards
C
Chipmunk
You may need to ensure that a "barcode" font is loaded in the font directory.
J
Jase
How do I load and get a "barcode" font? I have the scanner plugged in an
beepng as I scan a barcode but nothing is transfering into excel, I do have
excel open at the time.
Thanks
beepng as I scan a barcode but nothing is transfering into excel, I do have
excel open at the time.
Thanks
D
David McRitchie
If you purchased a scanner, I would think you got a CD with fonts; however,
that is certainly not always the case. You can obtain free barcode fonts
take a look at the related area of http://www.mvps.org/dmcritchie/excel/mailmerg.htm
if you still need an answer to the last question you asked. Actually the
barcode font would only apply to printing. You should get the numbers loaded
into the cell as noted in the original reply you got. I would assign a Helper
column alongside =A1 and format the helper column with the barcode font.
that is certainly not always the case. You can obtain free barcode fonts
take a look at the related area of http://www.mvps.org/dmcritchie/excel/mailmerg.htm
if you still need an answer to the last question you asked. Actually the
barcode font would only apply to printing. You should get the numbers loaded
into the cell as noted in the original reply you got. I would assign a Helper
column alongside =A1 and format the helper column with the barcode font.
J
Jase
Thanks guys. Fortunately I got it cranked up and have managed to get the
serial numbers into my excel spreadsheet. The problem was setting the correct
parameters for the scanner itself. Now I will have a play around and see what
else I can do with it.
serial numbers into my excel spreadsheet. The problem was setting the correct
parameters for the scanner itself. Now I will have a play around and see what
else I can do with it.
David McRitchie said:If you purchased a scanner, I would think you got a CD with fonts; however,
that is certainly not always the case. You can obtain free barcode fonts
take a look at the related area of http://www.mvps.org/dmcritchie/excel/mailmerg.htm
if you still need an answer to the last question you asked. Actually the
barcode font would only apply to printing. You should get the numbers loaded
into the cell as noted in the original reply you got. I would assign a Helper
column alongside =A1 and format the helper column with the barcode font.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Jase said:How do I load and get a "barcode" font? I have the scanner plugged in an
beepng as I scan a barcode but nothing is transfering into excel, I do have
excel open at the time.
Thanks