+ Reply to Thread
Results 1 to 3 of 3

AUTOMATION ERROR on MAC that work perfectly in Windows

  1. #1
    Registered User
    Join Date
    12-21-2019
    Location
    Caracas
    MS-Off Ver
    2016
    Posts
    2

    AUTOMATION ERROR on MAC that work perfectly in Windows

    Hello partners.

    I developed a macro in MS Excel 2016 for a client that uses MAC, the macro works perfectly in Windows, however, when it is executed in MAC it does not work and what is worse: It only shows a useless message "Microsoft Windows Visual Basic Automation Error" .

    I use Option Explicit in my code

    Do any of you know what could be the cause of this error?

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: AUTOMATION ERROR on MAC that work perfectly in Windows

    Did you go through the code step by step with F8?
    Or put some break lines in certain spots to locate the part where the error is
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: AUTOMATION ERROR on MAC that work perfectly in Windows

    You will have to show some code or workbook to get help on this.

    There are plenty of help with macros on Mac out there, but to narrow the search, help us first
    Last edited by nordicdust; 12-23-2019 at 07:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compile Error: Automation Error when opening in Mac, but not in Windows
    By kopite2002 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 11-19-2019, 12:34 PM
  2. Automation Error - Windows 10
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2019, 09:57 AM
  3. [SOLVED] Compile error with windows 7 and 8.1 VBA commands work in XP.
    By Epscan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2014, 09:59 AM
  4. [SOLVED] Code was working perfectly, but now will not work after an error window popped up...
    By ekf23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2014, 09:45 AM
  5. [SOLVED] Excel 2010 Macro not working on Windows 7 but same works perfectly on XP
    By rahulwagh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2013, 02:14 PM
  6. VBA now getting Runtime Error 13 - Type Mismatch but used to work perfectly
    By Royzer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 02:29 PM
  7. Getting this code to work on MAC (ERROR 68) - works fine on Windows
    By LT1511 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2012, 11:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1