Forum Discussion
abaul1981
Jun 29, 2023Copper Contributor
Compile error in hidden module: Sheet 1 error in Macbook on macros
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
Bronze Contributor
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.
abaul1981
Jul 03, 2023Copper Contributor
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 ?
- peiyezhuJul 03, 2023Bronze Contributorif possible upload your .xlam file,maybe someone has this kind of knowledge.
- abaul1981Jul 06, 2023Copper Contributor
- peiyezhuJul 06, 2023Bronze ContributorSub 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.