I built a shared x64 library (DLL) for use in Excel on Windows and wanted to use it on my Mac to save me starting a VM every time I needed it.
However, when the VBA code launches it says it cannot find the dylib. On searching the internet I have put the dylib in various locations and tried various path formats using both slash and colon delimited paths but to no avail and I am at the point of pulling out what remains of my hair! I would be grateful if someone could tell me where I need to locate this dylib and how to address it within the VBA.
At present the library resides in /Users/Bill/lib/ and I am using the same path within the VBA code but this doesn't work either!
I am running macOS Catalina v10.15.3 with Excel for Mac v16.33 (20011301) with an Office 365 Subscription.
However, when the VBA code launches it says it cannot find the dylib. On searching the internet I have put the dylib in various locations and tried various path formats using both slash and colon delimited paths but to no avail and I am at the point of pulling out what remains of my hair! I would be grateful if someone could tell me where I need to locate this dylib and how to address it within the VBA.
At present the library resides in /Users/Bill/lib/ and I am using the same path within the VBA code but this doesn't work either!
I am running macOS Catalina v10.15.3 with Excel for Mac v16.33 (20011301) with an Office 365 Subscription.