Barcode scanning with Excel

Chief1904

New Member
Joined
Jan 3, 2013
Messages
1
My office is trying to go paperless with our hunting program and issue ID cards with bar codes. I'm trying to have a barcode scanner be able to scan the ID card and pull up their information in excel or access. How can I do this? My boss doesn't want to spend $12,000 on a full setup of software and hardware. Any help would be great!
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Along the same lines, I'm using an HP barcode scanner gun. It obviously scans any barcode and then places the number (or barcode info) into the active cell. Besides using Worksheet_change, is there anyway to control if the scan is accepted? I don't want the scan to accept if the user is on the wrong sheet or wrong cell. I would be nice to be able to tell the scanner where to input the data. Thanks
 
Upvote 0
Hi Chief,

I'll make some assumptions on a possible solution to your scan-in and get info-back.

Scan the ID card number into A1.

Elsewhere on the Excel sheet you have a data base (table if you will) where all the ID card numbers of the hunters are listed, lets say column F.
In columns G, H, I, J, K are five items (you can have more if needed) of info that relate to the ID number in F. (Name, Address, Telephone No., Expire date of ID card, Blood Type, whatever...)

In the cells where you want to return that info you can use a VLOOKUP formula that will look something like this:

=VLOOKUP(A1,$F$1:$K$50,{2,3,4,5,6},0)

So the formula will take the value in A1 and look for it in column F and when a match is noted, returns the information in columns G, H, I, J, K.

Is this some what like what you are after?

I don't know anything about Access.

Regards,
Howard
 
Upvote 0
A barcode reader is like a keyboard in that when you can a barcode the numbers/letters go where ever the cursor is. Depending whether you are scanning directly into a cell in a spreadsheet or into a form textbox, validation of the scan can be done different ways. Either way, the scan will need to be compared to a list/database of barcode numbers and then after that; code to decide what to do with the scan.
 
Upvote 0
Hi Chief,

Have a look-see at this workbook I wrote for a school book distribution, as a possible solution for your scanning need. Of course it's the concept you will be looking at, not the school book distribution to students.

https://www.dropbox.com/s/blu89n0i6yfs4be/Scan%20Method%20Demo.xlsm

What you will see:

Sheet 1 is the scanned data read out. Note the Student ID no.s in column L to be used for the demo. The button clears the data.
Type a student ID no. in column A, hit enter, see the data that is returned. (this would probably be your hunter barcode scan)
Enter student no. 789 and see that no student has been assigned that number yet.
Don't confuse column D Barcode with anything to do with your barcode scanning, you will probably be scanning the hunter barcodes into column A, as mentioned, and returning pertinent data from sheet 2.

Sheet 2:

Instead of student information, a compiled data base pertinent to your hunters.

Regards,
Howard
 
Upvote 0
I remember with symbol barcode scanner you could create your own scan codes and program the scanner that you perform actions like CTRL-C, CTRL-S, CTRL-X and whatever you wanted.
I never tested to send a keyboard key combination to trigger a macro but it should work.
 
Upvote 0
i just took the scanner off our Pitney Bowes mail machine we use for scanning Delivery Confirmation racking numbers on out going mail..plugged it in to my pc , opened excel and it scanned every barcode i tried..USPS,FEDEX UPS, DHL..so maybe you dont need a barcode reader program?..
 
Upvote 0
No, you typically do not need any special software. A "barcode" is typically just going to return a set of numbers. A scanner is a device much like a mouse or keyboard. You can usually plug it into any computer and it works from the get go.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top