Clever Geek Handbook

Excel - "File not found: VBA6.DLL"

I have an Excel 2007 sheet with macros. When I click on the button, the message "File not found: VBA6.DLL" appears immediately

The problem is I have used this sheet forever and have never seen this problem before. I made very minor changes to the Macro code.

And I have 2 more sheets with identical macrocode in which I made the same changes. And these two sheets are working fine.

Any ideas?

+2


source to share


2 answers


In this order:



  • Check your references (Alt + F11, Tools-References) to see if any messages are MISSING and make sure Visual Basic for Applicatiions is checked.

  • Check directory C: \ WINDOWS \ system32 for VBA6.dll

  • You may need to register VBA6.dll (Start-> Run)

    Regsvr32.EXE "C: \ WINDOWS \ system32 \ VBA6.dll"

+4


source


I had the same problem with a shared file. The fix was as follows:

  • Stop sharing a file
  • Copy all macros; sheets, this book, modules and saved them in text format.
  • Save .xlsm as .xlsx file
  • Save the .xlxm file
  • Paste all macros into
  • Reset keyboard shortcuts and descriptions in macro options
  • Cancel the file


This worked without the need to go to IT professionals and get information about administrative authority.

0


source






More articles:


All Articles