Home

DLL declared in VBA in Excel for Mac 2016 not Found, Error53

%3CLINGO-SUB%20id%3D%22lingo-sub-738685%22%20slang%3D%22en-US%22%3EDLL%20declared%20in%20VBA%20in%20Excel%20for%20Mac%202016%20not%20Found%2C%20Error53%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738685%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20in%20Excel%20for%20Mac%20v%2016.26%20in%20two%20different%20Mac%20computers.%20I%20am%20calling%20a%20function%20'TestF'%20in%20a%20DLL%20'libTest.dylib'%20declared%20in%20VBA%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPrivate%20Declare%20PtrSafe%20Function%20TestF%20Lib%20%22libTest.dylib%22%20Alias%20%22_Z6test_fPc%22%20(ByVal%20Str%20As%20String)%20As%20Double%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFunction%20works%20like%20a%20charm%20in%20one%20of%20my%20Mac%20computers%2C%20but%20when%20called%20in%20other%20Mac%20computers%20reports%20the%20error%20message%20attached%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20844px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122244i9FA2348D6FA5CCED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-07-04%20at%2012.05.18%20PM.png%22%20title%3D%22Screen%20Shot%202019-07-04%20at%2012.05.18%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742529%22%20slang%3D%22en-US%22%3ERe%3A%20DLL%20declared%20in%20VBA%20in%20Excel%20for%20Mac%202016%20not%20Found%2C%20Error53%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742529%22%20slang%3D%22en-US%22%3EI%20would%20guess%20that%20the%20dll%20in%20question%20needs%20to%20be%20installed%20on%20the%20other%20computer%3F%3C%2FLINGO-BODY%3E
Alejandro Dopazo
Occasional Contributor

I am working in Excel for Mac v 16.26 in two different Mac computers. I am calling a function 'TestF' in a DLL 'libTest.dylib' declared in VBA:

 

Private Declare PtrSafe Function TestF Lib "libTest.dylib" Alias "_Z6test_fPc" (ByVal Str As String) As Double

 

Function works like a charm in one of my Mac computers, but when called in other Mac computers reports the error message attached:

 

Screen Shot 2019-07-04 at 12.05.18 PM.png

1 Reply
I would guess that the dll in question needs to be installed on the other computer?
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies