+ Reply to Thread
Results 1 to 4 of 4

VBA Fails when on Mac but works on Windows

  1. #1
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    VBA Fails when on Mac but works on Windows

    Hi all,

    I am trying to assist someone with their Crypto project, they have written some code in VBA to obtain the Crypto data. I've attached the file but according to my mac the part which does not work is here:
    Please Login or Register  to view this content.
    I also tried changing it to sub after reading some tutorials but can't get it to work. Is this something that is possible to rewrite for mac or one of those gems that cannot be completed unless you have windows?

    Really appreciate any help, thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: VBA Fails when on Mac but works on Windows

    CreateObject is the culprit. It's essentially Windows-only.

    No way to use this code on a Mac.

  3. #3
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    Re: VBA Fails when on Mac but works on Windows

    Is there any kind of alternative which will do the same function in a different manner or is it fully not possible to do what the user wants to achieve on a mac?

    Thanks for your quick response

  4. #4
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: VBA Fails when on Mac but works on Windows

    I don't have a Mac, so I have no idea whether there are Mac alternatives. Someone else would have to respond.

    FWIW, I just did a web search on Mac alternative for MSXML2.XMLHTTP, and the most reasonable result seems to be this.

+ 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. [SOLVED] Code fails in one file, works in copy?
    By JasonLeisemann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 12:20 PM
  2. VBA code works in one SUB and fails in a different SUB
    By jcaskey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2013, 11:54 AM
  3. Need help with vba coding which works in windows xp but not as well with windows 7
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-08-2012, 11:13 AM
  4. UDF works in 2003, but fails in 2007
    By Puff_Adder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2010, 06:21 PM
  5. Macro run fails, step through works.
    By SteveAlston in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2009, 11:37 PM
  6. ADO parameter object fails with AS400 when used in Windows XP
    By jr2112 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2006, 02:40 PM
  7. Macro works fine on PC; fails on Mac
    By marlea in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2006, 04:35 PM

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