Hello!

I need to convert mission critical workbooks with much VBA code from Excel 2003 to Excel 2013, of which some were originally created using Excel 97.

When running any VBA macro I get 0x80028018 errors. A similar problem is described in KB320369 - BUG: "Old format or invalid type library" error when automating Excel - however in my case it's

1. VBA, not .NET or VSTO and
2. I have installed the proper language packs.

I need to describe more detailed:

Even when I open the legacy workbook in 2013, create a new blank sheet, delete all old sheets and all VBA code, forms etc., put a new command button in, calling any new VBA sub, I get that error.

When I create a new workbook from scratch, put a new command button in, calling any new VBA sub, there is no error!

It also makes no difference, if I save it in compatibility mode xls or as new xlsm. See the screenshots.

I believe there is some legacy metadata in vbaProject.bin, which makes Excel 2013 choke.

Thanks!

L.

Run-Time Error Message:

Comparison of the zipped contents of "Book2", the newly created workbook, and "L_VK_1_min", the converted legacy workbook:

• Edited by asklucas 9 hours 28 minutes ago formatting

Just to visualize it:

1. Excel 2003 workbook created in 1997 (presumably using Excel 97) opened in Excel 2013:

2. Apparently identical newly created Excel 2013 workbook: