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

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

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