I've developed an application in Excel97 with a small set of VBA macros and
I update the sheets daily.

A couple of times I updated the sheets in Excel2003, successfully run the
macros and saved the file. After the handling in Excel2003 it is no more
possible to save the file in Excel97 without the message
"this file was created using a later version of Microsoft Excel ".

I have in Excel97 recreated the file by
- copying the worksheets from original file to a new Excel97 Workbook and
- Copied all macros via a notepad-file to the new Excel97 VBA module.

Now, I can successfully update worksheets and run the macros and save the
file without the message, but

as soon as I reopen the new file and accept the question if I want to enable
macros, the same message comes up when I try to save the file.

The macros are originally written in Excel 97 - no change has been made to
those macros in Excel2003. They run successfully in both Excel versions.

Doesn't anybody out there know what is/are different between those versions?
It appears that only when the file includes macros, the incompatibility
issue appears.
But all macros are source of Excel97???



--
-------------------------------------------------
Håkan Björkström
------------------------------------------------