Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Jase" wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks champ, I'll give it a whirl tomorrow!
"JoeUser" wrote: 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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You may need to ensure that a "barcode" font is loaded in the font directory.
"Jase" wrote: Thanks champ, I'll give it a whirl tomorrow! "JoeUser" wrote: 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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Chipmunk" wrote: You may need to ensure that a "barcode" font is loaded in the font directory. "Jase" wrote: Thanks champ, I'll give it a whirl tomorrow! "JoeUser" wrote: 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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote in message ... 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 "Chipmunk" wrote: You may need to ensure that a "barcode" font is loaded in the font directory. "Jase" wrote: Thanks champ, I'll give it a whirl tomorrow! "JoeUser" wrote: 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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "David McRitchie" wrote: 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" wrote in message ... 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 "Chipmunk" wrote: You may need to ensure that a "barcode" font is loaded in the font directory. "Jase" wrote: Thanks champ, I'll give it a whirl tomorrow! "JoeUser" wrote: 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 "Jase" wrote: 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? "JoeUser" wrote: 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 "Jase" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Does Excel support endnotes? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |