View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Compatibility issue? Excel97/2003

Perhaps you are saving as "excel 97,etc" instead of just saving as if it
were to be used in 2003?

--
Don Guillett
SalesAid Software

"HBj" wrote in message
...
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
------------------------------------------------