Compile error in hidden module: This workbook.

Anonymous
2010-08-19T09:56:57+00:00

I've got the following error after installing office 2010. It's only shown once I want to open/close the Excel:

Microsoft Visual Basic for Applications:

Compile error in hidden module: This workbook.

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2012-04-23T16:52:38+00:00

After searching for answers to this problem repeatedly I finally came up with this...if anyone besides me is still having this problem, hopefully this will help.

Excel shows a "compile error in hidden module: thisworkbook" when opened or closed.

This error occurs because 2 excel files are corrupted.

To stop the error from occurring:

If in Windows XP open the following folder:

C:\Documents and Settings\USERNAME\Application Data\Microsoft\Forms     where USERNAME is the current user

If in Windows 7 open the following folder:

C:\Users\USERNAME\AppData\Roaming\Microsoft\Forms     where USERNAME is the current user

Once the folder is located, delete these 2 files

ComctlLib.exd

MSComctlLib.exd

Excel should now open without the error message.

Note: Excel will create 2 new files (with the same names) in the folder, but they will not be corrupted.

Was this answer helpful?

200+ people found this answer helpful.
0 comments

58 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2015-03-05T23:15:32+00:00

    Hi RobAmick,

    I did this but problem remain the same. Here are some thing different which i noticed:

    1. When i delete those file fromC:\Users\USERNAME\AppData\Roaming\Microsoft\Forms, open Macro Excel file, those files ComctlLib.exd and MsComctlLib.exe won't create again. So this folder become empty now.
    2. Those file will be created in C:\Users\USERNAME\AppData\Local\Temp\Excel 8.0.
    3. On different systems, i can see the size of those file might be different meant it must be different version. Do you have any idea?

    Thank you.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-04T16:24:07+00:00

    I had the same problem for a user.  I had built a password protected workbook.  The workbook functioned correctly on my PC, but recieved the "Compile error in hidden module...." on his desktop.

    I went to his desktop, temporarity unprotected the workbook, opened VB Project, and tried to compile.  The compile failed, and the missing library was immediately visible in the Tools | References dialog.  I installed the missing library, and the problem was fixed.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-02-10T12:16:57+00:00

    Hi, what happened if after I have deleted those file, try to open excel file again but it won't create any new file?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-02-02T04:30:24+00:00

    The cause of this error is definitely creation of .exd files. In my case the .exd file was created in temp directory of local profile. It is a good idea to search for *.exd files in c:\users folder and delete them to resolve the issue.

    Was this answer helpful?

    0 comments