Excel 2003 Compile Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 19:16:07 GMT by s_ac5 (squid/3.5.20)
get the following error when you start Excel 2003 or Excel 2007: "Compile Error in Hidden Module: Distmon" Cause: The cause of this error is PDFMaker.xla, which loads at startup. Solution: The easiest solution compile error in hidden module module 1 is to delete PDFMaker.xla from your computer. Since Adobe Professional 8 uses DLL-addins to
Microsoft Visual Basic For Applications Compile Error In Hidden Module
add the toolbar in Excel, you can safely delete the PDFMaker.xla file on your computer. PDFMaker.xla may be at one or more
Compile Error In Hidden Module Excel 2010 Windows 7
locations on your computers. Typically, PDFMaker.xla is stored in your profile directory: C:\Documents and Settings\
Find/Replace add-in for Excel has stopped working, displaying the following error message: The error appears to be http://www.codedawn.com/index/-compile-error-in-hidden-module-message-in-excel a side effect of a recent update released by Microsoft. I don't know the details of exactly why this broke the add-in, and I'm not sure if http://stackoverflow.com/questions/29362479/compile-error-on-excel-2010-but-not-on-excel-2003 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 compile error 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 compile error in 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.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Compile error on Excel 2010, but not on Excel 2003 up vote 0 down vote favorite I can't explain what is wrong with this simple code. It works perfectly on Excel 2003, but in Excel 2010 it displays: Compile error: Sub of Function not defined. Can anyone explain why is there an error on Excel 2010? Sub Test_File_Opened() If IsFileOpen("D:\Test.xls") Then MsgBox "File is open!" Else MsgBox "File is closed!" End If End Sub excel vba share|improve this question edited Mar 31 '15 at 7:18 L42 12.4k52143 asked Mar 31 '15 at 6:59 MJ54 1015 1 Post the IsFileOpen function as well. It should be included when you transfer your code from 2003 to 2010. –L42 Mar 31 '15 at 7:19 2 This link might clarify it for you. IsFileOpen is not an inbuilt VBA function. –rusk Mar 31 '15 at 7:20 @rusk it doesn't explain why the UDF worked in xl 2003. MJ54, pls post your function. –brettdj Mar 31 '15 at 7:40 There is no function below the code. –MJ54 Mar 31 '15 at 7:53 @brettdj: Could be any of a million things. It's in another module the OP didn't copy. It's in an add-in. etc. etc. Bottom line is, the code is probably the one on this Microsoft page and just has to be made available in the new Excel 2010 workbook e.g. pasted into a module, or the add-in loaded etc. Not enough info here to diagnose properly, but the remedy is the same regardless. –Jean-Francois Corbett Mar 31 '15 at 8:03 | show 2 more comments 2 Answers 2 active oldest votes up vote 1 down vote The IsFileOpen function is not present in your code, this is the only possible explanation. You must declare it somewhere in your VBA module. Here are a couple of things to check: Did you misspell the procedure name? Try to call a procedure from another project without explicitly adding a reference to that project in the References dialog box. Specify a procedure that is not visible to the calling procedure. Declare a Windows dynamic-link library (DLL) routine or Macintosh code-resource routine t