VBA in Office 2011 on a Mac -- Error

[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?

 

[Michael Vilain]

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?

 

[Steve Maser]

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

 

[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.

 

[Steve Maser]

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