ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with VBA compatibility - Excel 2003 (https://www.excelbanter.com/excel-programming/300309-problem-vba-compatibility-excel-2003-a.html)

Frank Krogh

Problem with VBA compatibility - Excel 2003
 
I have successfully converted an Excel 2002 VBA-application to Excel 2000
(by removing some command options not available in VBA 2000).

Unfortunately, the application doesn't work at all in Excel 2003, returning
several "File error: data may have been lost" when I try to open the
workbook - even when the macros are disabled! The workbook sheet includes
some autoshapes grouped together, but they are not present when the workbook
is opened after the error messages.

The application is available at
http://www.npr.no/privspes/Les_inn_NPR-rapport.zip . (VBA project password
is "sikkerhet").

Is is really so bad compatibility between the Excel VBA 2000/2002 and Excel
VBA 2003?

Thanks for any suggestions on how to convert the application or possible
workaround.


Frank Krogh








Frank Krogh[_2_]

Problem with VBA compatibility - Excel 2003
 
The compatibility problem turned out to be the Autoshapes, not the VBA-macros

Fortunately, the Autoshapes seems to be backward compatible with Excel 2000.


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com