Microsoft Excel – VBA – Compile error: Can't find project or library SoapClient30

25 May, 2009 Roel van Lisdonk 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

4 Replies to “Microsoft Excel – VBA – Compile error: Can't find project or library SoapClient30”

KattyBlackyard says:

June 15, 2009 at 04:52

Hi, very nice post. I have been wonder’n bout this issue,so thanks for posting
Neil says:

March 29, 2011 at 18:13

Thanks for posting..It did solve my issue of removing the missing DLL and adding afresh.

Thanks !!
maarten Boer says:

July 18, 2013 at 14:27

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
Bhanu Potluri says:

February 2, 2015 at 23:01

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).