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