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

Question

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.

snowman55 · Answer

abaul1981&nbsp;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.&nbsp;

abaul1981 · Answer

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 ?

peiyezhu · Answer

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

abaul1981 · Answer

peiyezhu&nbsp;&nbsp;Please find the sheet attached. Kindly help.

peiyezhu · Answer

Sub Complete_Exit() Dim req As New MSXML2.XMLHTTP60Have 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.

Forum Discussion

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

Share

Resources