Simply pull the trigger on your scanner and listen for the sounds made by the laptop.
- Compatible with MS Excel.
- Requires a barcode scanner with a "Preamble" character set - this causes the scanner to send a special character before sending the characters it scanned. This allows the script to "lock out" the keyboard so as to prevent accidental overwriting of data in the spreadsheet. Non-printable preambles are recommended (Default is F8)
- Uses the COM interface - does not operate Excel via keyboard shortcuts.
- Marks found cells in green.
- Searches across ALL worksheets in the workbook.
- Excel does NOT have to be the active application when scanning.
- You can scan quicker than it can search the spreadsheet - searches are queued and processed on a FIFO basis.
- Scanned items that are not found are added to an extra worksheet called "!NotFound!"
- Spreadsheet is auto-saved on each scan.
- When an item is found, Text-To-Speech is used to tell you which worksheet it was found on.
This will either be numeric (ie it will say "One" for the first sheet) or named - if you name a Sheet "Sheet1|Hello", it would say "Hello" when it found an item on that sheet (ie use a pipe (|) symbol to specify a name)
- All settings are persistent and saved in an INI file.
https://github.com/evilC/Spreadsheet-Ba ... canner.ahk
(Assuming default keys).
1) Run the script.
2) Open the Excel spreadsheet you wish to search, and while it is the active application, hit F4 to "link" the script to this spreadsheet.
3) Ensure the preamble setting on your barcode scanner matches the Preamble Key setting in the script. This is normally done by scanning barcodes from your scanner's manual.
You may need to do the same for the Postamble (Terminator) setting, but most scanners default to Enter, which is correct for this script.
4) You may also need to configure your scanner to set the delay between keystrokes - most important is a short delay (1-10ms should do) between the preamble key and the scanned data. This is to give the script a chance to lock out the keyboard.
5) Scan some barcodes! Excel does not need to be the active application!