Excel Windows 2007 to Macro 2011 Office

[cheeze83]

Hi all

I'm having a bit of trouble. I built something for a client at work in Windows Excel 2007 - and they now have Mac with Office 2011, and the code no longer runs.

I've been having a look up online and trying to get my head round it, but I haven't been able to. Is anyone able to help me get in the right direction of getting this code suitable for a Mac on Office 2011?

Thanks in adance

Please Login or Register  to view this content.

[Izandol]

Do you have errors? If so, where?

One thing you must know is that you may only have one instance of application running therefore if Word is already running, CreateObject("Word.Application") will fail. YOu must test using GetObject(, "Word.Application") and if that will return Nothing then you may call CreateObject.

[cheeze83]

Hi

Thanks for your response, I am getting

Can't find object error for

Please Login or Register  to view this content.

Looking in the library and says MISSING: MJicrosoft 14.0 Object

But has 12?

Sorry - I am also 'self-taught' through trial and error, and the lovely contributor on here, so my knowledge probably isn't as extensive as most

[Izandol]

Are you looking in Mac or in Windows? Word 14 is Word 2010 in Windows but 2011 on Mac; 12 is 2007 for Windows and 2008 for Mac. If you must support both versions it is better to late bind your code and not use references.

[cheeze83]

I'm looking in Windows myself, which is the biggest problem I am facing, trying to adapt it for Mac with Office 2011

If 14 is 2010, would explain why I am missing it (operating on 2007) - wonder then if originally was built in 2007, for windows, would the top lines need to reference the new object - as I'm assuming the Mac user in 2011 wouldn't be missing this reference?

[Izandol]

It is better if you remove the reference, then use late bound code:

Please Login or Register  to view this content.

[cheeze83]

You're an absolute star - thank you so much