W
Walt Weber
Hi,
On opening a file that includes an Auto_Open VBA procedure
(There is no Workbook_Open procedure), just before
finishing the procedure, or maybe just after, Excel tries
to reopen the file. Since I can see on screen that the
custom menu is loaded, I know it's at least very near the
end of the Auto_Open procedure.
Dialog box contents are:
"Microsoft Excel" in dg box bar
'Filename' is already open. Reopening will cause any
changes you made to be discarded. Do you want to
reopen 'Filename'?
'YES' and 'NO' buttons at bottom
I 'NO' is chosen all works fine. If 'YES' is chosen, the
file is reopened, then all works fine. This only occurs
on the first opening; hence it's not a loop of continually
reopening.
This problem seems to only happen while using Windows
NT4.0 SP5 and Excel 2000. And, it happens if the file is
double clicked from within Windows Explorer. Opening
from the Excel 'Open' dialog box is no problem. A
shortcut pointed to just the file has the problem, but a
shortcut pointed first to Excel, then a space, and then
the file works fine.
I don't know if this is Windows, Excel, or the VBA
procedure. Any ideas.
Thanks,
Walt
On opening a file that includes an Auto_Open VBA procedure
(There is no Workbook_Open procedure), just before
finishing the procedure, or maybe just after, Excel tries
to reopen the file. Since I can see on screen that the
custom menu is loaded, I know it's at least very near the
end of the Auto_Open procedure.
Dialog box contents are:
"Microsoft Excel" in dg box bar
'Filename' is already open. Reopening will cause any
changes you made to be discarded. Do you want to
reopen 'Filename'?
'YES' and 'NO' buttons at bottom
I 'NO' is chosen all works fine. If 'YES' is chosen, the
file is reopened, then all works fine. This only occurs
on the first opening; hence it's not a loop of continually
reopening.
This problem seems to only happen while using Windows
NT4.0 SP5 and Excel 2000. And, it happens if the file is
double clicked from within Windows Explorer. Opening
from the Excel 'Open' dialog box is no problem. A
shortcut pointed to just the file has the problem, but a
shortcut pointed first to Excel, then a space, and then
the file works fine.
I don't know if this is Windows, Excel, or the VBA
procedure. Any ideas.
Thanks,
Walt