| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel and VB
Keeping track of worksheet names is a good idea if your doing this with code.
Create string variables for various sheets, when you know one is opem in the code, populate the variable with that name then you can refer to various workbooks like workbooks(var1).activate sheets(1).cells.select workbooks(var2).activate selection.paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple instances of Excel (Multiple workbooks) | Setting up and Configuration of Excel | |||
| Using RTD with multiple instances of excel | Excel Discussion (Misc queries) | |||
| Multiple Instances of EXCEL.EXE | Excel Discussion (Misc queries) | |||
| Multiple Instances of Excel | Excel Discussion (Misc queries) | |||
| Multiple instances of Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
