How to fix macro in excel for mac?

Question

Macros

Actually such a question. There is an excel file of the bank registry, which, using a macro, should be converted into a file, which is then encrypted, signed and sent to the bank ... But I came across the fact that this macro does not want to be executed in excel on a poppy, it says that it cannot create an object and points to an error (as I understand it) in this line DTAddress = CreateObject("WScript.Shell").SpecialFolders("Desktop") &
Application.PathSeparator how to fix this issue? I tried to put Windows excel in parallels, but it didn't help... Thank you in advance for your help!

Answer 1

Just try to write the path in DTAddress, for example DTAddress = "/Users/krishnacore/".
Hardly Mac has WScript.Shell :-)