I have several DLLs that i make in VB6, and whenever I update them by
adding new functions, all the references that my workbooks made to these
DLLs are now broken and i have to reset them. Why does this happen? Is
it because the workbooks are bound to the GUID of the DLL, which perhaps
changes on every compilation? If so, is there anyway in VB6 to compile
DLLs with the same GUID? Or is there any programmatic way to update the
references to my workbooks so that i won't have to keep resetting them
manually?