help with Excel VBA Declare statement

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

Code:

---

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).

Quote:

---

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

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