Home

Urgent Help Please - Macros not working on Mac only

%3CLINGO-SUB%20id%3D%22lingo-sub-694461%22%20slang%3D%22en-US%22%3EUrgent%20Help%20Please%20-%20Macros%20not%20working%20on%20Mac%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20some%20trouble%20with%20the%20attached%20spreadsheet.%26nbsp%3B%20I%20think%20I%20need%20a%20replacement%20for%26nbsp%3BMSXML2.ServerXMLHTTP.%26nbsp%3B%20I%20have%20seen%20that%20I%20may%20be%20able%20to%20do%20this%20with%20Query%20tables%20or%20something%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F15981960%2Fhow-do-i-issue-an-http-get-from-excel-vba-for-mac%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F15981960%2Fhow-do-i-issue-an-http-get-from-excel-vba-for-mac%3C%2FA%3E%26nbsp%3B%20However%20I%20am%20not%20sure%20how%20I%20might%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20really%20great!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mconnolly31
Occasional Contributor

Hi, 

 

I am having some trouble with the attached spreadsheet.  I think I need a replacement for MSXML2.ServerXMLHTTP.  I have seen that I may be able to do this with Query tables or something here: https://stackoverflow.com/questions/15981960/how-do-i-issue-an-http-get-from-excel-vba-for-mac  However I am not sure how I might do this.

 

Any advice would be really great!

 

Thanks in advance