LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Broken? Daniel[_3_] Excel Worksheet Functions 11 February 8th 08 03:25 PM
Broken x-axis in excel KE Charts and Charting in Excel 1 May 7th 07 05:10 PM
Macro broken with workbook name change Annabelle Excel Discussion (Misc queries) 2 February 3rd 06 12:48 AM
How do I create a broken X axis in Excel? TSW Charts and Charting in Excel 1 December 28th 05 03:08 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"