View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan[_27_] Alan[_27_] is offline
external usenet poster
 
Posts: 1
Default 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