I have an application folder which contains a DLL. I also have a Office Template with a macro that needs to access the DLL. I know at runtime (via a Registry entry) what folder the DLL is in, but not at Design Time. Declaring the functions in the DLL via the "Declare Sub Lib "
is a Declaration which presumably(?) must be resolvable at Compile-Time.

If I put the DLL in the System32 directory, VBA will find it. I would prefer not to (who wouldn't?). Is this just a limitation of VBA, or is there a technique I'm not aware of that will allow me to declare the actual location of the DLL at runtime?