Has my macro broken Excel?
All
I've started writing VBA macros. I have however, upset Excel. When I
click on an Excel spreadsheet file in a folder, Excel opens as an
application, but the associated file does not open. If I go into Excel
and open the file from there, all is OK.
The only bit of VBA I can see which may have done this is:
Windows("myfile.xls").Activate
Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True
This may or may not be the reason. I'd appreciate any comments or
suggestions.
Regards
Alan
|