How do I get a scanner to input to an excel spreasheet

BillMaintenance · #1 02-26-2015, 11:34 AM

I have a inventory sheet set up, what I am trying to do is simply have the capabilities to have a scanner scan a bar code and remove inventory from the sheet.

My basic program is attached.

charlesdh · #2 02-26-2015, 12:21 PM

HI,

Your post does not have a attachment.

BillMaintenance · #3 02-26-2015, 12:26 PM

Yes,
I realized this after I posted it. I am afraid I added the attachment incorrectly.

I think that I have did this correctly now. This is a small sample of the spreadsheet. The main sheet contains some if statements to describe the parts needed ordered.

BillMaintenance · #4 02-27-2015, 05:34 AM

Hi,

After additional investigation it appears to me that something is wrong with my OS for windows or the scanner itself. What I am seeing is that upon triggering the scanner when it is hooked to the computer, it should in most cases input itself to most Microsoft Office application. Am I correct in my understanding of this?

charlesdh · #5 02-27-2015, 12:31 PM

H,

I'm not sure if this helps. But a friend of mine has a file that he uses scanner on. This is what he said.

Quote:

you have to have a cell activated, then scan barcode and should read the info.
On my program I have a textbox that when you open it its ready for input

BillMaintenance · #6 03-02-2015, 05:40 AM

Thanks,
I will try this.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula In Excel To Prompt User To Input Date	pclutts	Excel Programming	4	08-31-2014 12:45 PM
Input data in Excel and get info from Access	zkibz	Excel Programming	1	08-14-2014 05:17 PM
Input from excel, output to word	conradin	Word	3	04-20-2011 07:48 PM
Insert image from Scanner option gone?	webcan	Word	8	11-11-2010 08:05 AM
Problem with scanner in office 2003	Lionheart94	Office	0	12-17-2008 03:52 AM