View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Huey Huey is offline
external usenet poster
 
Posts: 4
Default Excel Automation Application is shared with interactive?

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.