| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility issue? Excel97/2003
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 ------------------------------------------------ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compatibility issue? Excel97/2003
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compatibility issue? Excel97/2003
Excel 2002/2003 have a more sophisticated security model than Excel 97. I
suspect when you enable macros, some default settings are made and then recorded in the file when you save it. While the fileformats are compatible, excel 97 discards information it does not understand and thus the prompt. That would be my guess. -- Regards, Tom Ogilvy "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 ------------------------------------------------ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compatibility issue? Excel97/2003
In other words,
Excel 97 and Excel 2003 are _not_ compatible. So, what can be done? Do not use same app in 97 and 2003? What are the security settings? Can they be checked? Håkan "Tom Ogilvy" wrote in message ... Excel 2002/2003 have a more sophisticated security model than Excel 97. I suspect when you enable macros, some default settings are made and then recorded in the file when you save it. While the fileformats are compatible, excel 97 discards information it does not understand and thus the prompt. That would be my guess. -- Regards, Tom Ogilvy "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 ------------------------------------------------ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compatibility issue? Excel97/2003
You have shown that they are compatible. The question was why the message -
I gave my best guess. I assume the question really is how can I operate between 97 and 2003 and eliminate the message as well. I don't have an answer for you on that. -- Regards, Tom Ogilvy "HBj" wrote in message ... In other words, Excel 97 and Excel 2003 are _not_ compatible. So, what can be done? Do not use same app in 97 and 2003? What are the security settings? Can they be checked? Håkan "Tom Ogilvy" wrote in message ... Excel 2002/2003 have a more sophisticated security model than Excel 97. I suspect when you enable macros, some default settings are made and then recorded in the file when you save it. While the fileformats are compatible, excel 97 discards information it does not understand and thus the prompt. That would be my guess. -- Regards, Tom Ogilvy "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 ------------------------------------------------ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compatibility Issue | Excel Discussion (Misc queries) | |||
| Excel 2003 compatibility issue | Excel Discussion (Misc queries) | |||
| 2003/2007 Compatibility Issue - Hidden Sheets | Excel Discussion (Misc queries) | |||
| Compatibility Issue between files created in 2003 but opened in 20 | Excel Discussion (Misc queries) | |||
| Excel 2002/2003 Macro Compatibility issue | Excel Programming | |||
![HBj[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
