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: 2
Default Read-Only alert when opening 2nd instance of Excel

Does anyone have any pointers to suppressing the message "Personal.xls
is locked for editing" when opening a 2nd instance of Excel? I usually
run some pretty big reports during the day, and while they're running,
I'll have a Windows scheduled task try to open an Excel workbook with
some VBA in the Open event. This opens a 2nd instance of Excel, but it
won't actually execute until I hit the 'Read Only' button. I'd like to
bypass this alert altogether if possible.

I thought setting Application.DisplayAlerts = False in the Open event
of the XLS file being opened by the 2nd instance would work, but it
doesn't. Perhaps the 1st instance controls the value of DisplayAlerts?

 
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
Help! Excel 2007 opening in a new instance Ryan Martin Excel Discussion (Misc queries) 1 September 4th 08 10:26 PM
opening a new instance of Excel gb4 Setting up and Configuration of Excel 0 April 10th 08 04:48 PM
opening form in new instance of excel riva91 Excel Programming 1 May 9th 06 03:01 PM
keep Excel from opening 2nd instance widman Excel Discussion (Misc queries) 0 April 30th 06 01:35 PM
Keep Excel from opening new instance widman Excel Discussion (Misc queries) 7 October 1st 05 01:53 AM


All times are GMT +1. The time now is 06:40 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"