Nick Computer Services
Computer & Services => Technical & Tutorial => Topic started by: Nick on May 23, 2012, 06:02:31 PM
-
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.