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
|