Z
ziltmilt
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?
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?