CODEWITHSUNDEEP
vbaexcel
dhanya
dhanya

Reputation: 265

VBA: DLL error while opening specific module

My excel workbook is popping up with DLL error message when I try to open few of the modules. Where the code inside those module works perfectly...( I have one button which execute those code) Any idea what will be the reason or how to solve this problem ?? Because I have to make few changes on those code

img

Thank you

Upvotes: 1

Views: 2508

Answers (1)

ashleedawg
ashleedawg

Reputation: 21639

If you're running Office 64-bit or alternative installations, then the DLL could be located elsewhere.

Search your system for the file:

  1. Press Windows Key + F

  2. Type REFEDIT.DLL and hit Enter

    For example, mine is located at:

    C:\Program Files (x86)\Microsoft Office\root\Office16\REFEDIT.DLL

Once you locate the file:

  1. CTRL + C copy the entire path

  2. In Excel's VBA Editor, go Tools → References

  3. Un-check the MISSING: reference

  4. Click Browse...

  5. CTR L + C paste in the correct path and hit Enter

  6. Scroll to find REFEDIT.DLL and double-click it, Click OK

The issue should be resolved.

Upvotes: 2

Related Questions