I have a .dll file here that I want to reference in my Excel file.
All I do is just click Tools >> References and then locate the .dll
file to include it in the list.

No problem there. Got my code in the .dll file to work just fine.

The problem here is that if I move the location of the Excel file and
the .dll file, whether it be in another PC on the network or just
another folder on my hard drive, my Excel macro crashes. It won't run
because I changed the location of the .dll file.

I'm guessing I need to do some late binding eh? The problem is how...

Here's the code:
---------------------------------------------------

'I declared these public so I can use it anywhere on my workbook.
Public dllFunction As TemplateDll.cmFunctions
Public dllProcedure As TemplateDll.cmProcedures

Private Sub Workbook_Open()
'Assigned the references to variables
Set dllFunction = New TemplateDll.cmFunctions
Set dllProcedure = New TemplateDll.cmProcedures
End Sub

---------------------------------------------------

The code above works just fine...I just need it to work whenever I
move BOTH my Excel file and my .dll file anywhere on my hard drive or
on network...