Using custom dylib on Mac with Excel

Bill Moo

New Member
Joined
Feb 15, 2020
Messages
3
Office Version
365
Platform
Windows, MacOS
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

New Member
Joined
Feb 15, 2020
Messages
3
Office Version
365
Platform
Windows, MacOS
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

New Member
Joined
Feb 15, 2020
Messages
3
Office Version
365
Platform
Windows, MacOS
OK, I've made some progress on this and I have now found what appears to be the correct location for the dylib:
Code:
/Library/Application Support/Microsoft/
However, rather than saying the library cannot be found I now get this:

Code:
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?
 

Forum statistics

Threads
1,085,755
Messages
5,385,696
Members
401,967
Latest member
Sullivag2

Some videos you may like

This Week's Hot Topics

Top