#NAME? error when scanning bar code

[sinski]

I have a spreadsheet that users need to use to scan in bar codes. When they try to scan the bar code the cell populates with #NAME ?

The cell is formatted as General

Any thoughts about what is causing this?

 

[Jeffrey Mahoney]

What is actually in the cell?

 

[sinski]

There is nothing in the cell. The user is supposed to click the cell so it becomes the active cell, then scan the bar code.

 

[sinski]

Forgot to add: when they try to scan the bar code, the cell is then filled with the error code: #NAME ?

 

[Jeffrey Mahoney]

I've worked with barcode scanners before. By what you're describing, it sounds like the driver for the barcode scanner isn't properly installed. Usually, it just adds a serial number to the cell. I'm checking with another person.

 

[Jeffrey Mahoney]

Confirmed. Plug and play. Reinstall the driver or get a new driver from the manufacturer.

 

[Jeffrey Mahoney]

This is a USB barcode scanner? Not a serial port scanner?