Cell change WB1 -> textbox WB2

L

Ludo

Hi,

I know that the title isn't realy what it should be, but here i go.

I have a little barcode application running for a DYMO 450 label
printer in Excel using forms.
This works fine.

When the utility is started up, I hide the Excel application
(Application.visible= False)

Then we start a second instance of excel and open a certain workbook
(data log).
In this workbook is data placed in several columns, but i'm only
interested in the column having a serial number.

What i've been asked for is if it's possible whenever there's a cell
change in a cell in the data log file that this can be copied to the
label printers textbox.

here a little how it should work.

1- start the label printer utility (Excel = not visible, only the
applications userform
2- start second instance of excel
3- open a data log file
4- when there's a cell change in column A (only at exit of the cell !)
copy this value to the labelprinter utility
5- labelprinter print the label.

note that both run in a separate instance of Excel.

Adding a new selection form to make a choise of what they like to do
is possible (printing from a hand scanner or data from the data log
file)

Can this be done, and how to do it.

Any help apreciated,
Regards,
Ludo
 

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