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: 74
Default Copy cell change to other workbook

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


 
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
Copy Sheet In Same Workbook But Do Not Know how to Change Cell Ref Kevin L[_2_] Excel Programming 0 July 31st 07 03:00 PM
How to Change Source Data after copy sheets from another workbook? davy Excel Programming 3 January 27th 07 06:58 PM
Change location of auto saved back up copy of shared workbook? Roxanne M Excel Discussion (Misc queries) 4 May 24th 06 01:50 AM
Change workbook sheet reference using cell A1 to change a vairable Reed Excel Worksheet Functions 4 January 20th 05 07:15 PM


All times are GMT +1. The time now is 07:29 PM.

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"