Auto Detect Data, Auto Print Data, Auto Erase Data Loop

  • Thread starter Gamma's and Ruiter's
  • Start date

G

Gamma's and Ruiter's

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.
 
Ad

Advertisements

G

GammaRuit

this works but if i have a scan come in thats say 11 lines long it
prints 1 line then it prints the next. doesn't wait for the whole scan
to come in to print it.
also it doesn't go back to a1 with the blinking cursor to await the
next input.

close though..
any ideas?

cv
 
G

GammaRuit

Apologies Ron,

1. Its read in line by line.
2. Your right about the blinking cursor. It just blinks when I double
click the cell. Forget that. I just want to go back to A1 as you
showed me how in the previous message.

cv
 
G

GammaRuit

How do you know when the last line has been read in?

Every scan is a different amount of data.

It constantly populates line after line. When its done it stops. There
is nothing in the decoded text to indicate that its finished.

I can program my barcode generator to print out something specific as
the very last line of the decode. Maybe END or COMPLETE or THANK YOU
 
Ad

Advertisements

G

GammaRuit

How do you get the information into Excel?

I'm thinking you could just run a test after each line, and print out therange after you read or Last Line code; adapting from what I've already written.


I click A1

I take my scanner scan a QR Code. say my QR is encoded with:

Hi
How
Are
You


It prints it out line by line as it you were typing really fast.

A1 Hi
A2 How
A3 Are
A4 You
 
G

GammaRuit

Works Ron ! Thank You

Do I need to Define A Header and Footer within the Macro?
I tried to apply it in the layout and it won't work.

What would be a better description of the interface be? The type of
Scanner?
Would you like to see a video of how it works so you can understand
the process?

Chris
 
Ad

Advertisements

G

GammaRuit

I wasn't seeing the header and footer because i didn't input the data
on the left header.
I'm using a receipt printer right now so it was off the page.

So i put the header and footer on the left and it prints. but it moves
into where my data is printing as well.
it is overlapping slightly. i would assume i just have to play with
formatting? nothing to do with macro code right?

cv
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top