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.

4 Comments

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

    maarten Boer
  2. 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).

    Bhanu Potluri

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.