VBA Not Working on MacOS

**recalling** · 11-09-2020, 05:32 PM

Hello everyone, I need your help with a VBA code that works on Windows but when it's used on MacOS throw the ActiveX Error 429.

Please Login or Register  to view this content.

The bold text is the code that don't allow me to use it on MacOS. It would be great if you could rewrite my code to be able to use this VBA on MacOS because I'm no expert and this is important for my work.

I'll wait patiently for your answers. Thank you.

**hrlngrv** · 11-09-2020, 05:50 PM

Scripting.* is provided by SCRRUN.DLL, the Windows Script Host. That's Windows-only. No Mac equivalent AFAIK.

Rule of thumb: EVERYTHING involving CreateObject or GetObject is Windows-only. If you want similar functionality on Macs, YOU have to recreate it yourself.

Sorry to be blunt, but you need to find alternatives.

Tangent: Macs lack C: drives, so Set DiscoDuro = FSO.GetDrive("c:") would also cause problems on Macs.

If you're trying to get serial numbers of physical drives or partitions, Macs have terminals and complete POSIX tool sets. You should be able to get physical drives' serial numbers using

hdparm -I /dev/[hs]d? | awk '/^\/dev\// { d = $1 }; /Serial Number:/ {print d, $3 }'

CORRECTION: the command above is only for Linux. For Macs, you'd need to use /usr/sbin/diskutil info. I have no experience with it, but it seems to be the command and argument you'd need to use.