Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a barcode scanner hooked up to excel. It decodes the encoded
text in the barcode it scans. The barcodes scanned may have up to 40-50 lines and 600 + characters of data. It will all stay in column A and could populate all the way down to line 40-60. I'm trying to write a macro for this with not too much luck. When the information is scanned, the macro needs to start at A1 sense how many cells were populated with data, maybe it fill A1 - A12 or maybe A1-A60, it needs to auto prints those cells, then erases the information that was scanned in and awaits the next scan, and does it all over again until i stop it. It only prints once when it receives new data. Example: Basically its an autoprint as if you were to do a price check in a store. you put the item under a scanner and the screen shows you the price when its scanned, how ever instead of the screen output i want it to print to a printer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto show data but without using Auto Filter | Excel Discussion (Misc queries) | |||
auto transfer data in sheet2 (selected data) | Excel Worksheet Functions | |||
how to auto-print if data is on report after each sort? | Excel Programming | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions |