Author Topic: Compile error in hidden module: This workbook  (Read 5532 times)

0 Members and 1 Guest are viewing this topic.

Compile error in hidden module: This workbook
« on: May 23, 2012, 06:02:31 PM »

Offline Nick

  • Administrator
  • Platinum Member
  • *
  • Posts: 46028
  • Karma: +1000/-0
  • Gender: Male
  • NickCS
    • http://www.facebook.com/nickcomputerservices
    • http://www.twitter.com/nickcomputer
    • Computer Chiangmai

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.


 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)


Related Topics

  Subject / Started by Replies Last post
48 Replies
21865 Views
Last post March 08, 2009, 12:40:24 PM
by IT
0 Replies
10902 Views
Last post March 08, 2009, 01:04:55 PM
by IT
0 Replies
3493 Views
Last post July 03, 2010, 03:14:50 PM
by Nick
0 Replies
2961 Views
Last post September 17, 2010, 04:32:56 PM
by Nick
0 Replies
3434 Views
Last post September 17, 2010, 04:46:29 PM
by Nick
0 Replies
1475 Views
Last post February 21, 2016, 09:01:03 AM
by Nick
0 Replies
8135 Views
Last post September 04, 2018, 05:07:01 PM
by Nick
0 Replies
883 Views
Last post July 01, 2021, 12:58:21 AM
by siamwebsite
0 Replies
796 Views
Last post December 27, 2021, 09:59:57 PM
by bosszi
0 Replies
3739 Views
Last post August 18, 2024, 10:16:50 AM
by Nick