Compile error in hidden module: Sheet 1 error in Macbook on macros

[abaul1981]

Hi All,

When i run macros in my Macbook air it gives me the above error. The same i can run on windows machine. Pls help.

[#2]

@abaul1981 

It is quite unlikely that anyone in this community can resolve your problem with just that information.

A person who has access to the code in the hidden module Sheet1 must inspect that code to determine the problem. My guess is that the code is written using a Windows-specific feature. There may be a workaround for Excel for Mac, or there may not be.

In short, discuss this with a person who supports this software.

[#3]

Hi sir......i don't have any such person in my contacts. Can you kindly help me out in case you or anyone of your contacts has any knowledge of the same ?

[#4]

if possible upload your .xlam file,maybe someone has this kind of knowledge.

[#5]

@peiyezhu 

Please find the sheet attached. Kindly help.

[#6]

Sub Complete_Exit() Dim req As New MSXML2.XMLHTTP60

Have you viewed the vba codes?
This New MSXML2.XMLHTTP60 is not available in Mac VBA.

In another words,this vba only run on Windows system rather than Mac Os.

I guess you have to use another way to get information from the web site like PHP or Go.

Or run VBA on windows PC.