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: 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.
 
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
What gives... Application.Interactive = false Kieranz[_2_] Excel Programming 3 March 5th 07 03:58 PM
Interactive Workbook on Shared Drive J.W. Aldridge[_2_] Excel Programming 0 August 11th 06 03:19 PM
Application.Interactive=true ignored? John.Greenan Excel Programming 1 June 9th 05 02:43 AM
Excel automation and Shared Workbooks VadimT Excel Programming 2 March 9th 05 03:30 AM
Excel automation and shared workbooks Matthew L. Butcher Excel Programming 0 December 4th 03 02:58 AM


All times are GMT +1. The time now is 08:04 AM.

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"