help with Excel VBA Declare statement

[VBAhack]

I have a bunch of Declare statements that expose various routines in a DLL:

Public Declare Sub routinexyz Lib "C:\$User\MYDLL.dll" (variable list)

Is there any way to use a const whose value is "C:\$User\MYDLL.dll" instead of the actual string in every statement? It allows an easy way to change the value of the Lib name (or path).

[westconn1]

Is there any way to use a const whose value is "C:\$User\MYDLL.dll" instead of the actual string in every statement?

no
ideally the dll should be in the system32 directory, or os equivalent, then no path would be required

[VBAhack]

Thanks for the tip. That's a lot better than what I have