VB scripts from Office 97 that no longer work in Office 2003
"Christian Johansson" skrev i meddelandet
...
Now, I noticed something very strange. I create a new .xls document every
year with the macros that now don't work with Office 2003. If I try to run
the macros in documents from 1995-1998 or earlier they work fine. These
..xls
documents were originally created with Excel 4.0 and Excel 5.0 under
Windows
3.1. On the other hand, if I run exactly the same macros in documents from
1999-2003 they don't work. These documents were created with Excel in
Office
97 under Windows 98. Even if I record a very simple macro that just writes
something in a cell, I get an error when trying to run it with Office
2003.
No, that was not completely true. If I try to open one of the documents from
1995-1997 that were created with Excel 5.0, I get "Error in loading DLL".
Then, I get a message that Excel has repaired the file, that the Visual
Basic project has been lost and that I should save it. On the other hand, if
I try to open the document from 1998 that was created with Excel 5.0 and
later converted to Office 97, the macros work. However, if I try to open the
documents from 1999-2003 that use the same macros and that were entirely
created with Office 97, I just get an application error when trying to run
the macros. It seems like Microsoft have ****ed up in the backwards
compatibility.
|