Patrick O'Beirne sysmod wrote a class set that addresses this issue.īe sure to stop by Patirk's Blog to say thanks! Also there is a chance he has a newer version. Pulling the Answer from the comments to prevent link rot. Write 2 completely separate routines to do the same thing ( please let this not be what needs to happen): isMac = CheckIfMac ' Change dictionary variable to some other data type that is Mac friendly and provides the same functionality Use a Mac plugin that enables use of Dictionaries on Macs ( my favorite option if one exists)ĭo some kind of variable switch like the following: isMac = CheckIfMac.The following are the 3 cases I can think of as being possible solutions: My question is, is there a way to make this work on a Mac? Which is the result of using the Tools > References > Microsoft Scripting Runtime library. I recently had a user attempt to use it on a Mac and received the following error: Compile Error: Can't find project or library I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |