working with two microsoft object libraries

[davidnew3754]

Hi there

I have some code which I'm running through excel which then uses the Microsoft 12.0 object library. This works fine as all the users have microsoft office 2007. However, we have one new user on Office 2010. When this user runs the macros it runs fine but then when this user saves the document and a 2007 user then goes to run the macros it can't find the object. Having looked through the reference library it is looking for microsoft 14.0 object library when the 2010 user has saved it.

Does anyone know a solution to this?

 

[davidnew3754]

Just to say I have found the solution. It was because I was using early binding. I switched to late binding and this now works.