missing libraries in Excel for Mac

Question

I have an xlsm file that relied on these three libraries, among others:

1. Microsoft ActiveX Data Objects 2.5
2. Microsoft Outlook 14.0 Object Library
3. Ref Edit Control

My version of Excel is 15.39 (171010)

Where can I obtain these, or are they not available yet?

If they are not available yet, when are they due to be released?

Thanks!

Moved from: Office / Excel / Microsoft Office Programming / Office 2016

Answer 1

1. Microsoft Active0X Objects 2.5

This library has never been available for the Mac. Active-X is open source software that was never ported to the Mac. You will never get this library because it does not exist.

2. Microsoft Outlook 14.0 Object library.

This library is included with Office 2011 for Mac, and Office 2016 for Mac up to and including version 15.39. In the Visual Basic Editor choose Tools > References.

The current Insider Fast build of Office for Mac uses Microsoft Office 16.0 Object Library. This new library will replace the version 14 object Library in future releases of Office for Mac. Your code may have to be modified to take advantage of the newer version.

The RefEdit control is available in the UserForm toolbox in Office 2011. You can add RefEdit controls programmatically in Excel 2016 for Mac. The Toolbox will return to the Visual Basic Editor in a few weeks and you soon will be able to use it there, too.

Office 2016 for Mac comes with a built-in ODBC driver for Microsoft SQL Server. Whatever code you have now, you should update it to use the version 16 object library, and you should use standard Excel controls instead of Active-X controls. Doing these things will make your code run cross-platform Mac and PC.

It is very possible to use VBA to run SQL queries cross-platform if you do it right.

Answer 2

They are not available for MAC. Unfortunately, Microsoft doesn't publish the calendar for its releases, so it is not possible to say when they will be released.

A hard way would be to look into code and try to modify so that the code doesn't use this. But i understand it would be very difficult.

Answer 3

They are not available for MAC. Unfortunately, Microsoft doesn't publish the calendar for its releases, so it is not possible to say when they will be released.

A hard way would be to look into code and try to modify so that the code doesn't use this. But i understand it would be very difficult.

Thanks.

Unfortunately the sole purpose of the code was to read and write SQL data via an excel macro.

It's cheaper for us use to vmware on our macs, with code that already works, rather than waste money developing work arounds with Excel for Macs.