Excel/Excel and barcode scanner
Good Afternoon Tom, hopefully you can help me as I have seen your advice and help all over the internet. I will try to explain in short detail on what I'm trying to accomplish, I have a sample room in an R&D department and I want to scan parts in and out of the room as someone needs them. I plan on using excel to do this but haven't a clue on how to start. I would like to be able to scan a part and cell that has a date in or date out would come up corresponding to the part and the user could simply type the date in the correct field if they were taking it out or returning it. Please let me know what other info you need.
Thanks in advance for the help
Master Spas Inc
First, I don't own any barcode scanners and never have. I have talked to a few people that have used them so I understand how they have been used in some instances. Basically, for the systems I have knowledge of, the barcode scanner acts as an input device - a keyboard if you will. The user scans in a marking/barcode and the barcode scanner types the number as input to the computer. So the scanner itself or any associated software handles sensing the code and translating it into a number.
If you select a cell in Excel and scan in a barcode on say your part, then the coded number will be "typed" into that cell. Usually the barcode sends a return/enter character at the end.
So you would have the editing of a cell trigger a macro that does some work for you such as finding that number in a list.
In the past, I have helped people write some code to react to the scanning of the number into a specific cell and doing some limited processing related to that number. They however already had defined their layout and the action they wanted triggered.
So hopefully that provides you the background information you are seeking.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here