Ludo wrote on 1/26/2011 :
Hi,

I made a little application when scanning a barcode, this is
immediatly printed with a DYMO 450 label printer.
Works fine, no problem here.

I'm been asked for to add, whenever they place a value into a certain
worksheet (other workbook), that this will be printed on the label
printer.
If possible, i don't want to change a lot to the label print
application because it would be used in other divisions of the company
too. But adding a form to select depending on what they really want to
do with the label printer is possible.

The situation would be like this.
1- Start the label printer application wich is a .xls file. I hide the
Excel application (application.visible=False)
2- Start a second instance of Excel.
3- open a certain workbook where there will be numbers placed in a
column (column A - 11 digit number).
4- when there's a number added in this column, send it to the label
printer application to print.

So what i needto know is how the technique works to send a value in a
workbook (cell change event) to another workbooks form (textbox).

Any help appreciated.
Regards,
Ludo

Uh, why do you feel you need to use 2 instances to do this?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc