This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is there a way to reference a relative path in a VBA Declare statement? I have a shared library that I want others to be able to use when I send them the Excel file and the dylib file. I don't want everyone to have to open the VBA editor and change the path to where they have it saved. So instead of:
Declare Sub Test Lib ":user:name:location:lib.dylib" (ByVal....
I'd like it to automatically search for the dylib in whatever folder the Excel file is located.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You're in luck! Excel MVP Ron DeBruin has made a page that explains how to deal with sandboxing and saving files
I'll be sending it to people to put on their separate computers. I don't want to have to explain to them how to show hidden folders and then place the library in a specific folder. Plus, supposedly, Excel should be looking for the library in the current Excel folder anyway. At least that's what MS says for the PC.
I think it needs to be an absolute path, not a relative path. This is probably complicated with sandboxing. You should put the lib in a place common to all of your users.