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?
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?
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?
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?
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?
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?
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?
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?
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" <[email protected]> wrote in message news:[email protected]...
> 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?
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" <[email protected]> wrote in message news:[email protected]...
> > 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?
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks