Excel 2003 vs Excel 2008 - VBA

[dulitul19]

Hey guys,


Currently, some people of my company have Excel 2003 and others have 2007 or 2010. There are some macros already created for 2007 but since we are going to update the company's system and thus the Excel version to 2010 some of the macros will not work. Currently they dont work also if I try to run macro created in 2007 on 2003 Excel version. It pops up a messaage Compile error- project or library missing.

When I go to references I can see for example Outlook 12.0 Obj. library missing and a couple of more. What should I do to fix the problem so I can run macros created in 2007 or 2010 to 2003 and vice versa?

Thank you

[kbkumar]

Hi - My understanding is that 99% of 2003 version macros should work in 2007 or 2010. However 1% doubt is for the 9 object models that have been removed in 2010 (I recall some changes were made in reference libraries as you also pointed out). Incase you are using some of these models that have been removed I believe you have no option but to replace them with the new ones. See the link below that highlights "Potentially Impactful changes in 2010"

http://blogs.technet.com/b/office_re...ect-model.aspx

Hope this helps...

[MarvinP]

Hi,

And from Kbkumar's link above I find http://www.microsoft.com/en-us/downl...ng=en&id=15001 which claims it will check the compatibility between versions to tell what has changed.

[dulitul19]

Ok..I understand..but lets say I go to references and in my case it says Outlook 12.0 Object library missing, since my 2003 excel has Outlook 11.0 Object library then how can I replace with the newer version? I am going to replace everything that says is missing with newer versions but do I do it?

[MarvinP]

Replacing all old .dll with new ones would be one way to do it.

My understanding is that when you write VBA code you do things like Format(Expression,[Format],First day of week, other stuff) using your older version of Excel. Then you try to use this VBA command with a newer version of excel where the parameters have changed or improved with the newer version. The newer version doesn't know how to deal with the older parameters.

If you can find, in your code the command that is the old one and replace it with the newer one you shouldn't need to change the references to that DLL.

I hope this makes sense. This is my understanding about old and new references and how they work/improve and need to be upgraded.

[dulitul19]

Should I replace all DLL files from say Excel 2010 into the |Excel 2003 folder? Please elaborate on that. Thanks