I am having trouble with updating a reference to a DLL file programmatically. Let's call this file MYDLL.dll. I check whether MYDLL.dll is missing (i.e. IsBroken). If so, I try to remove it from the Object Library by using the
Thisworkbook.Vbproject.References.Remove (item) statement.
However, the item is still present in the Reference List(but now the tick box is unchecked). I now have multiple entries of MYDLL.dll, but how do I actually delete these items from the list?
My program should check whether the MYDLL.dll is broken, if so remove the reference (or delete it), and then add MYDLL.dll again using the AddFromFile statement.
No errors occur when running the code, but MYDLL.dll isn't updated with the new path I specified, it still uses the original path of the MYDLL.dll which I removed from the Object Libary.
I have been working on this problem for over a week now, but I think I am missing something fundamental. I am not sure whether this is my code, or my computer being the culprit, but any help would be appreciated!
Old post: http://p2p.wrox.com/topic.asp?TOPIC_ID=37933