Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE stop Excel version popup!!
I hope someone can assist me with this problem. In
Access, I am exporting data to an Excel 2000 spreadsheet then sending via Outlook to users. Everything was working UNTIL I added code to format the Excel file. I used: Worksheets(sheetName).Range("A1:A26").Formula = "='Sheet2'! $A$1:$Z$1" Now every time a file is created I get an Excel popup message stating the file is in Excel 95/97 version and asks if I would like to overwrite it with the latest version. What did I do wrong? How do I stop it? Is there anyway to fix my code to prevent this or a way to automatically select 'Yes' to the popup? Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
How do I stop the popup "Enable/Disable Automatic Refresh"? | Excel Discussion (Misc queries) | |||
How do I stop the Office popup window "Some files can contain viru | Excel Discussion (Misc queries) | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) |