I have a .NET program that obtains XML via Excel (which obtains from a web service). (And if one is wondering why such a long "tunnel" has be established, please don't ask - that's a lengthy political topic that would be out of scope).
Within it is a VBA function which returns an IXMLDOMNodeList. Since the Excel.Run() method in .NET only views it as an object it has to be casted. Today the code running on my machine just bombed out on me with "specified cast is not invalid" exception.
The first time i inherited this project I hit the same error but was able to resolve it by re-referencing the correct MSXML library. Now, I have tried _all_ versions of MSXML library to no avail. The Excel project references MSXML 3.0 and matching it did not help. The odd thing is the very same binaries I passed to a colleague's laptop run fine. Yes, I have done the _mandatory_ reboot of my machine but that didn't help.
Has anybody ever seen such a thing? thanks,
The melody of logic will always play out the truth. ~ Narumi Ayumu, Spiral