I am encountering the following message when I use Excel 2007 to open an Excel 2003 file.
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
The VBA code (Application.DisplayAlerts = True) does not function properly to select "Yes".Excel 2007 Displayed Message Upon Opening File
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Excel 2007 Displayed Message Upon Opening File
You do not have the required permissions to view the files attached to this post.
Regards,
John
John
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel 2007 Displayed Message Upon Opening File
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)
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
Hans