Excel 2007 Displayed Message Upon Opening File

jstevens
GoldLounger
Posts: 2631
Joined: 26 Jan 2010, 16:31
Location: Southern California

Excel 2007 Displayed Message Upon Opening File

Post by jstevens »

I am encountering the following message when I use Excel 2007 to open an Excel 2003 file.
untitled.png
The VBA code (Application.DisplayAlerts = True) does not function properly to select "Yes".

Example:
Application.DisplayAlerts=True
Workbooks.Open Filename:=????????

Any ideas as to a workaround? By-the-way, the PNG file attached looks distorted when posted. Any ideas as to why the distortion?

Thanks,
John
You do not have the required permissions to view the files attached to this post.
Regards,
John

User avatar
HansV
Administrator
Posts: 78596
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel 2007 Displayed Message Upon Opening File

Post by HansV »

What if you use

Application.DisplayAlerts = False

Images wider than 640 pixels and/or taller than 480 pixels will be reduced in size when posted. You can click on a reduced picture to see it full size (click again to close the popup)
Best wishes,
Hans