25 May, 2009
4 Comments
0 categories
If you have a VBA macro in Microsoft Excel and a webreference to a webservice, you might get the famous Compile error: Can’t find project or library SoapClient30.
In mine case it wasn’t missing the C:\Program Files (x86)\Common Files\microsoft shared\OFFICE12\MSSOAP30.DLL but an old reference to the Office 11 components library.
Solution
> Open the Microsoft visual basic editor
> Tools > References…
> Remove all dll’s with "MISSING" for it, if you don’t have any start with deleting de selected dll until a dll appears witch is missing.
Tags: Excel
Hi, very nice post. I have been wonder’n bout this issue,so thanks for posting
Thanks for posting..It did solve my issue of removing the missing DLL and adding afresh.
Thanks !!
Hi, I have seen this suggestion often, but my problem is:
If the “can’t find….” error appears, the tools/references are greyed out and I am in a loop of error, even have to force shutdown Excel
Hey Maarten!
That happens after the “can’t find” error appears.
Close the excel book, re-open it again and edit the code before running it (so that the error doesn’t show up).