LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Auto Detect Data, Auto Print Data, Auto Erase Data Loop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto show data but without using Auto Filter LP Excel Discussion (Misc queries) 1 April 8th 09 12:06 AM
auto transfer data in sheet2 (selected data) deen Excel Worksheet Functions 1 May 9th 08 01:57 PM
how to auto-print if data is on report after each sort? Steve Excel Programming 0 October 29th 07 03:33 PM
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
How can I auto-refresh auto-filters when data changes? Mike@MPWco Excel Worksheet Functions 0 July 4th 06 12:50 PM


All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"