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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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