| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save changes in Excel 97 from file created in 2000
Try
application.DisplayAlerts = False Activeworkbook.Save Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Michael" wrote in message ... I have a shared file that users can run a macro, some using Excel 2000 and I am using 97. The Macro is date dependant and runs to the date specified which is then saved for various reports. When I run it in 97 it will not save as the file was created in a later version of Excel, can I remove all references to the file version before the macro continues?? or is there another way of saving the changes?? Any ideas would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save changes in Excel 97 from file created in 2000
Tom
Thanks, unfortunately I have already tried this, the macro doesn't fall over it just does not save the changes. I believe it is because the message about being created in a later version of excel defaults the save option to No. Thanks Michael "Tom Ogilvy" wrote: Try application.DisplayAlerts = False Activeworkbook.Save Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Michael" wrote in message ... I have a shared file that users can run a macro, some using Excel 2000 and I am using 97. The Macro is date dependant and runs to the date specified which is then saved for various reports. When I run it in 97 it will not save as the file was created in a later version of Excel, can I remove all references to the file version before the macro continues?? or is there another way of saving the changes?? Any ideas would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save changes in Excel 97 from file created in 2000
application.DisplayAlerts = False
Activeworkbook.SaveAs ActiveWorkbook.FullName, xlWorkbookNormal Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Michael" wrote in message ... Tom Thanks, unfortunately I have already tried this, the macro doesn't fall over it just does not save the changes. I believe it is because the message about being created in a later version of excel defaults the save option to No. Thanks Michael "Tom Ogilvy" wrote: Try application.DisplayAlerts = False Activeworkbook.Save Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Michael" wrote in message ... I have a shared file that users can run a macro, some using Excel 2000 and I am using 97. The Macro is date dependant and runs to the date specified which is then saved for various reports. When I run it in 97 it will not save as the file was created in a later version of Excel, can I remove all references to the file version before the macro continues?? or is there another way of saving the changes?? Any ideas would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 shuts down when attempting to save a file | Excel Discussion (Misc queries) | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Save a csv or text file in Excel 2000 with choice of separator | Excel Discussion (Misc queries) | |||
| Excel 2000 cannot save and create temp file | Setting up and Configuration of Excel | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
Hybrid Mode
