S
Steven
I have a file File01.xls that has a macro that opens file File02.xls with :
Private Sub MacroOpenFile02()
Workbooks.Open Filename:= "C:\File02.xls", Password:="aoaoao"
Application.Run "'C:\File02.xls'!Autpen"
Windows("File01.xls").Close (0)
End Sub
If I already have the file open and accidentally click the macro to open it
again I will get a message that the file is already open, do I want to reopen
the file Yes, No. If I click Yes it opens File02.xls again and all is ok but
if I click No then I get an error. How do I handle this situation.
Thank you,
Steven
Private Sub MacroOpenFile02()
Workbooks.Open Filename:= "C:\File02.xls", Password:="aoaoao"
Application.Run "'C:\File02.xls'!Autpen"
Windows("File01.xls").Close (0)
End Sub
If I already have the file open and accidentally click the macro to open it
again I will get a message that the file is already open, do I want to reopen
the file Yes, No. If I click Yes it opens File02.xls again and all is ok but
if I click No then I get an error. How do I handle this situation.
Thank you,
Steven