Copy cell change to other workbook

[Ludo]

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

 

[GS]

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?

 

[Ludo]

Ludowrote on 1/26/2011 :











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

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

When i run an Excel application using FORMS, there's no way to open a
new workbook using the instance that runs the FORM application.
I hide also the Excel environment using the application.visible =
false code.
So when i start the FORM application, i see only the form on screen,
the excel sheets, toolbars, ... are invisible.
When i double click on a xls file, i'll see the 'busy' pointer on
screen, but nothing happens.
If i start a second instance of Excel, i can open xls files again.

Ludo

 

[GS]

Ludo used his keyboard to write :

When i run an Excel application using FORMS, there's no way to open a
new workbook using the instance that runs the FORM application.
I hide also the Excel environment using the application.visible =
false code.
So when i start the FORM application, i see only the form on screen,
the excel sheets, toolbars, ... are invisible.
When i double click on a xls file, i'll see the 'busy' pointer on
screen, but nothing happens.
If i start a second instance of Excel, i can open xls files again.

Well, in order for us to help you we'll need more info.

What is FORMS?
How did you make your bar code printing app?
What is this FORM app that your 1st instance of Excel runs?
How do you create the 1st instance of Excel?
Why is the 1st instance hidden?
How do you start a 2nd instance of Excel?

 

[Ludo]

Well, in order for us to help you we'll need more info.

What is FORMS?

FORMS is an Excel VBA written application that prints scanned barcodes
on a DYMO450 label printer.
This application uses Userforms, so there's no code in the worksheets
of this application (workbook)

How did you make your bar code printing app?

Using VBA, Userforms + Module code

What is this FORM app that your 1st instance of Excel runs?

See above

How do you create the 1st instance of Excel?

Double click on the Excel shortcut icon.

Why is the 1st instance hidden?

Because it's neater on the screen than seing the non used Excel
worksheet.

How do you start a 2nd instance of Excel?

Double click on the Excel shortcut icon after the start of the barcode
print application (FORM)

If you want me to send you the whole code for the barcode scan
printer, send me your mail address.
I check in this code also if the labelprinter is connected to the pc
or not.
If not, there appears an error message and after click on the close
button the application is closed.

Regards,
Ludo

 

[GS]

Ludo was thinking very hard :

FORMS is an Excel VBA written application that prints scanned barcodes
on a DYMO450 label printer.
This application uses Userforms, so there's no code in the worksheets
of this application (workbook)

Using VBA, Userforms + Module code

See above

Double click on the Excel shortcut icon.

Because it's neater on the screen than seing the non used Excel
worksheet.

Double click on the Excel shortcut icon after the start of the barcode
print application (FORM)

If you want me to send you the whole code for the barcode scan
printer, send me your mail address.
I check in this code also if the labelprinter is connected to the pc
or not.
If not, there appears an error message and after click on the close
button the application is closed.

Regards,
Ludo

Send your complete file here. (Replace the uppercase words with their
appropriate keyboard characters)

gesansomATnetscapeDOTnet