View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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