Share via

Excel VBA on Mac

Anonymous
2016-08-08T08:51:30+00:00

Hi, I am using Office 365 and I have some excel macro which will connect to MS Access database using ADODB connection. It's working fine when I am running from any PC or TP except Mac system. When I am running from Mac system, it is giving an error. When I gone though the error I noticed there is no option to enable reference under Tool -> References. Is there any possibilities to connect MS Access database through Excel VBA in Mac system? Is there any Special MS Access package available for Mac.?

Microsoft 365 and Office | Install, redeem, activate | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-11T12:49:15+00:00

    Active-X does not, never has, and never will run on Macintosh. You will have to find another way to do what you want without Active-X controls.

    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-08-13T13:21:24+00:00

    AODBC does not work on a Mac.

    To connect to a Microsoft Access database you must connect using a Mac ODBC driver. This article explains how to do it in Excel 2011

    http://www.agentjim.com/MVP/Excel/OfficeAndAccess.html

    Excel 2016 does not have a working Microsoft Query editor, which is a big drawback unless you are skilled in SQL syntax.

    0 comments