1 out of 1 members found this post helpful.
Re: EagleEye Super Powerful Tool for Optimization & Planning
Originally Posted by
samuraial
Compile error in hidden module:Run GE File
Same for all the other save as etc...
B/R
Solution:
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.
Bookmarks