| 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 |
| 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) | |||
Threaded Mode
