Computer & Services > Technical & Tutorial

Compile error in hidden module: This workbook

(1/1)

Nick:
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.

Navigation

[0] Message Index