VBA in Office 2011 on a Mac -- Error

B

Bob Leibowitz

We're trying to move a sophisticated VBA tool created on a Wintel
machine to a Mac using Office 2011. We've run into a runtime error
(4231), "The AddOLEControl method or property is not available in Word
for the Macintosh."

Is there any workaround for this, perhaps a differently-named tool?
 
M

Michael Vilain

Bob Leibowitz said:
We're trying to move a sophisticated VBA tool created on a Wintel
machine to a Mac using Office 2011. We've run into a runtime error
(4231), "The AddOLEControl method or property is not available in Word
for the Macintosh."

Is there any workaround for this, perhaps a differently-named tool?

The workaround is to not use VBA. But you knew that, right?
 
S

Steve Maser

Bob Leibowitz said:
We're trying to move a sophisticated VBA tool created on a Wintel
machine to a Mac using Office 2011. We've run into a runtime error
(4231), "The AddOLEControl method or property is not available in Word
for the Macintosh."

Is there any workaround for this, perhaps a differently-named tool?


My suggestion would be to find the exact line of code that fails and
submit it up on Microsoft's forums at mactopia.com

I know there are some of the Excel product managers/engineers reading
those forums, so they might be able to fix this.


And, if you have access to Office 2004 -- especially if it works
*there*, they'll (eventually) end up fixing this.

- Steve
 
B

Bob Leibowitz

My suggestion would be to find the exact line of code that fails and
submit it up on Microsoft's forums at mactopia.com

I know there are some of the Excel product managers/engineers reading
those forums, so they might be able to fix this.

And, if you have access to Office 2004 -- especially if it works
*there*, they'll (eventually) end up fixing this.

- Steve

You'll recall that MSFT dropped VBA for Office 2004, so there's no
chance of it working there.
 
S

Steve Maser

Bob Leibowitz said:
You'll recall that MSFT dropped VBA for Office 2004, so there's no
chance of it working there.


You mean Office 2008, right?

Office 2004 may work.

- Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top