Compile Error In Hidden Module Thisworkbook
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 00:02:16 GMT by s_hv987 (squid/3.5.20)
Find/Replace add-in for Excel has stopped working, displaying the following error message: The error appears to be compile error in hidden module thisworkbook phstat a side effect of a recent update released by Microsoft. I
Compile Error In Hidden Module Thisworkbook Phstat2
don't know the details of exactly why this broke the add-in, and I'm not sure if
Compile Error In Hidden Module Thisworkbook Office 2010
it's caused by a Windows update or a Microsoft Office update. However, after scouring the Internet for a while, I came across a solution. Here are http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/compile-error-in-hidden-module-this-workbook/5da89258-34fa-4bcc-96bc-223787da6ada the steps to restore the add-in's functionality: Close Excel Open a command prompt with admin privileges Run the following two commands: For 32-bit Windows: regsvr32 -u c:\windows\system32\mscomctl.ocx regsvr32 c:\windows\system32\mscomctl.ocx For 64-bit Windows: regsvr32 -u c:\windows\syswow64\mscomctl.ocx regsvr32 c:\windows\syswow64\mscomctl.ocx Open ExcelUsually that solves the problem, although the same "Compile error in hidden module" error http://www.codedawn.com/index/-compile-error-in-hidden-module-message-in-excel can sometimes be caused by corrupted Excel files. So if the above steps don't do the trick, there is one other possible solution you can try: Close Excel Open Windows Explorer In the Windows Explorer address bar, type %appdata%and press Enter In the resulting list of subfolders, find and open the Microsoft folder In the Microsoft folder, find and open the Forms subfolder In the Forms folder, rename or delete the following two files (if they are present): comctllib.exd mscomctllib.exd Open Excel (it will automatically recreate the aforementioned files as it needs them)Hope that helps! In : Excel add-ins Previous post: QuickMonth... Tags: regex find replace excel add-in compile error hidden module « Back to posts Please enable JavaScript to view the comments powered by Disqus. blog comments powered by Disqus Custom Search Categories Excel add-ins(2) Firefox add-ons(3) Icons(1) QMC(2) XUL(1) Subscribe to this blog Designed by Arcsin Make a Free Website with Yola.
Error in Hidden Module Module 1/ 2/ 3 (Tax Query by Harmeet) Make Knowledge Free SubscribeSubscribedUnsubscribe37,79837K Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report https://www.youtube.com/watch?v=taeQkJ5THvQ Need to report the video? Sign in to report inappropriate content. Sign in Transcript http://www.ozgrid.com/forum/showthread.php?t=75199 Statistics 59,829 views 22 Like this video? Sign in to make your opinion count. Sign in 23 3 Don't like this video? Sign in to make your opinion count. Sign in 4 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This feature is not compile error available right now. Please try again later. Published on Jul 31, 2013Using Windows XP service pack 2 and getting this bug when trying to generate XML using ITR workbook I must admit that this was a strange bug for i personally didn't face it since i have a service pack 3 for windows XP but few people using service pack 3 also complain of this bug .One of my subscriber's while compile error in trying to fill the return (excel workbook ITR 1 )was getting this message .After analysing the message he got via his send email screenshot and going through his comments , i understood that it was not easy for me to replicate the problem because it seemed to be a operating system issue and in my parent laptop ,it didn't seem a good idea to virtualise (create a seperate system for this version of windows XP),so i virtualised my other laptop and yes the bug did came in service pack 2 , .Basically the VB coding done vide modules used to generate the Extended mark up document don't compile properly with versions of windows XP OS lesser than service pack 3 version...so people using windows XP service pack 2 might face this problem ,because when i installed windows XP service pack 2 in one of my 5 laptops , i got the same error ,Firstly pressing alt +F11 opens up the visual basic editor which shows the module which the developer has coded for the excel workbook to work and generate the XML ,Since clicking the XML throws up this error , it can be presumed that the OS with which it does has some compatibility issue ,next would be be to downl
Way | Trading Add-ins For Excel | Convert Excel Into Calculating Web Pages Excel Web Pages | Produce Clean Efficient VBA Code Every Time | Build Automated Trading Models In Excel | Excel Web Pages | Excel Video Training Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts What's New? Advanced Search Forum HELP FORUMS Excel General Compile Error In Hidden Module: Thisworkbook Excel Training / Excel Dashboards Reports If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above. Click here to view the relaunched Ozgrid newsletter. Results 1 to 8 of 8 Thread: Compile Error In Hidden Module: Thisworkbook Thread Tools Show Printable Version Search Thread Advanced Search August 15th, 2007 #1 huangker View Profile View Forum Posts I agreed to these rules Join Date 15th August 2007 Posts 2 Compile Error In Hidden Module: Thisworkbook Hi all, Thanks for having me here. I get the error message "Compile Error In Hidden Module: Thisworkbook" every time i start excel 2007. I've only installed it recently and only settings I have changed in excel is install the add-ins solver and data analysis. I've also had Nitro PDF 5 Pro installed before Office 2007 was installed. I have recently uninstalled Nitro PDF5. I'm not a coder and so I havent messed around with marcos etc. How do I get rid of this issue in excel 2007? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote August 15th, 2007 #2 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts 31,927 Re: Compile Error In Hidden Module: Thisworkbook See this only search result from the MSKB. Also see the Possible Answers above. Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel Reply With Quote August 16th, 2007 #3 huangker View Profile View Forum Posts I agreed to these rules Join Date 15th August 2007 Posts 2 Re: Compile Error In Hidden Module: Thisworkbook I've had a look at the ms knowledge base and it seems that the one linked was about a specific script. For me, the message appears in every file open or even when I create a new file. I press alt-f11 to g