Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a VBScript that is creating an Excel.Application object and writing to
workbooks\worksheets in the background. This operation takes hours to complete and if I open a spreadsheet to do other work while my script is running, this other workbook opens in the application window my script created. This causes my script to fail when it attempts to control the Application object. How can I prevent any other interaction with the Application object my script creates? I want to automatically open a new Application window when I manually open a workbook. Hope this makes sense and someone can tell me how to fix this. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What gives... Application.Interactive = false | Excel Programming | |||
Interactive Workbook on Shared Drive | Excel Programming | |||
Application.Interactive=true ignored? | Excel Programming | |||
Excel automation and Shared Workbooks | Excel Programming | |||
Excel automation and shared workbooks | Excel Programming |