VBA compile error when opening Excel 2010 file in Excel 2003

[Yuffster]

Good afternoon all,

I have a built a file using Excel 2010 that will also be used by Excel 2003 users.

There is extensive VBA code within the file that works fine when the file is opened in 2003 initially. However, if a 2010 user makes any changes to the file, even if they save as an xls., the VBA will then display a compile error when re opened in 2003.

I have checked the code and the more specific issue seems to be the library/references.

So, first question: is this just a conversion issue? And secondly, is there a way to fix it so users of both versions can use the file?

Many thanks!

 

[RoryA]

What references to other applications do you have set? Late binding is probably the simplest solution.

 

[Yuffster]

It looks like the issue is when it re opens in 2003, the Microsoft Windows Common Controls 6.0 (SP6) is missing. Not sure if there is an automatic workaround for that?

 

[RoryA]

That's not really an Office version issue - some computers will have it based on OS and installed programs, others won't (and 64bit Office can't use them at all) . Are you actually using those controls?

 

[Yuffster]

Hi Rory

Looks like it can live without that reference so I will remove it entirely.

Boy do I feel embarrassed that it was something so simple!