| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Questions about opening a workbook in code
Hello All
when i open a workbook in code, does it open in the same instance of excel, or a brand new instance. i have a workbook which i am using as a "dashboard" and i want it to open other workbooks, but i would also like those to load seperately in the "background" and not take focus from the workbook with dashboard. anyone got a suggestion? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Questions about opening a workbook in code
1. It's the same instance
2. maybe this: .... application.screenupdating = false x = activeworkbook.name 'open the files you want. 'after all the files are open then windows(x).activate .... -- MacGuy "DawnTreader" wrote: Hello All when i open a workbook in code, does it open in the same instance of excel, or a brand new instance. i have a workbook which i am using as a "dashboard" and i want it to open other workbooks, but i would also like those to load seperately in the "background" and not take focus from the workbook with dashboard. anyone got a suggestion? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit VBA Code without opening the workbook | Excel Programming | |||
| Error on opening more than one workbook containing the same code | Excel Programming | |||
| error code while opening a workbook | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| Performing code without opening the Workbook | Excel Programming | |||
Linear Mode
