Just to add:
Where you declare the .dll, you can append the excel worksheet location via 'ActiveWorkbook.Path' to the start - so you can bundle the worksheet and .dll together without having to put the .dll in other folders.
- Code: Select all
Declare Function SomeDLLFunc Lib ActiveWorkbook.Path & "\pl1000.dll"
Just be aware that without some extra tweaks, you cannot just put both files to the root dir (i.e. c:\ alone) as you'll double up on slashes.