Using custom dylib on Mac with Excel

[Bill Moo]

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.

 

[Bill Moo]

In case it wasn't obvious, I thought I'd add that I have built a version of the library to run on the Mac using XCode. On re-reading my post this wasn't obvious and it reads like I am trying to use the Windows DLL when in fact I'm using libServices.dylib as built by XCode via CMake.

 

[Bill Moo]

OK, I've made some progress on this and I have now found what appears to be the correct location for the dylib:

/Library/Application Support/Microsoft/

However, rather than saying the library cannot be found I now get this:

Error Signature:
Exception: EXC_BAD_ACCESS
ExceptionEnumString: 1
Exception Code: KERN_CODESIGN_ERROR (0x0000000127533000)
Date/Time: 2020-02-16 14:37:46 +0000
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Bitness: x64
Application Version: 16.33.0.20011301

Does anyone have any thoughts on what is needed to resolve this?