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.
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.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Hi
Thanks for your response, I am getting
Can't find object error for
Looking in the library and says MISSING: MJicrosoft 14.0 ObjectPlease Login or Register to view this content.
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
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.
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?
If my answer helped pls click the star =)
It is better if you remove the reference, then use late bound code:
Please Login or Register to view this content.
Last edited by Izandol; 01-30-2014 at 12:08 PM.
You're an absolute star - thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks