Make DLL to be available in all VBA projects
I am adding reference to a DLL in my VBAProject for a MS Excel file. It works fine for current document. However, when I create new Excel book I have to go to References and check the same DLL again. Is there a way to make my DLL be always included in all VBA projects?
Re: Make DLL to be available in all VBA projects
Moved to Office Development
Re: Make DLL to be available in all VBA projects
what type of dll,if it is a registered dll, it may be possible to use with creatreobject, then no reference is required
or try like this
ThisWorkbook.VBProject.References.AddFromFile "certcli.dll"