excel compile error in hidden module distmon visual basic Clayhole Kentucky

Address Pikeville, KY 41501
Phone (606) 422-2680
Website Link
Hours

excel compile error in hidden module distmon visual basic Clayhole, Kentucky

fix worked for me just fine Like Show 0 Likes(0) Actions 7. Do I uninstall Adobe Acrobat Reader again and then go through the registry to remove ALL instances of of Adobe I find. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 8th, 2007,08:24 AM #4 erik.van.geit MrExcel MVP Join Date Feb 2003 Location Belgium 3272 Testelt Posts 17,829 Hi, The only thing for a layman like me is to know that these were in the hidden mode.

If this doesn't work, be suspicious of Adobe Acrobat as this often loads integration which fails. (You can test this by quickly un-installing the acrobat and re-start Excel. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Can anyone help ?? I really need to use PHStat2 as I have an exam soon.

Re: "Compile Error in Hidden Module: Distmon" (David_P._Hahn) Apr 25, 2007 9:01 AM (in response to (dork_92618)) I called Adobe first for support... Re: "Compile Error in Hidden Module: Distmon" (B._Rosati) Feb 29, 2008 5:26 AM (in response to (dork_92618)) Deleted the folder: \\Computername\c$\Documents and Settings\UserFolder\Application Data\Microsoft\Excel\XLSTART and it works!! i am technical but not a pogrammer or anything like that. Look for a file called pdfwrite.xla or similar (with Excel closed) and remove it.

My XLStart folder was empty (didn't contain any pdfmaker files). Instead they resided in the documents and settings tree, with one instance in every user account on the computer. I have three computers with the same issue, I am about two steps from stopping all updates to Adobe and using some other form of similar software. Re: "Compile Error in Hidden Module: Distmon" (Aandi_Inston) Jan 10, 2008 11:56 AM (in response to (T_Constable)) If you uninstall Acrobat or Reader it will damage whatever is left - so

Aaron Wissner 148,469 views 29:23 Loading more suggestions... Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Ask Your Own Question Moving From One Module To Another - Excel Excel Forum I have code broken out between two different modules due to size limitations in a single module. I've tried to deselect the add-ins but they pop back up in next workbook.

Thanks Wabbitt Quazzywabbit, Jan 9, 2005 #12 tjsimons23 Joined: Apr 28, 2005 Messages: 1 I ALSO GOT THIS FIX TO WORK WITH OFFICE 2003 PROFESSIONAL. The time now is 07:44 AM. It's located here: C:\Documents and Settings\yourname\Application Data\Microsoft\Excel\XLSTART delete the pdfmaker in here and you should be home free. Home Exel : Visual Basic: Compile Error In Hidden Module : Distmon Similar Topics | Similar Excel Tutorials | Helpful Excel Macros Exel : Visual Basic: Compile Error In Hidden Module

If it stops working, uninstall all Adobe Reader and Acrobat products and reinstall what you need. (Of course, make sure you have all the disks and serial numbers you need to I have removed every "PDFMaker" from the hard drive. Please try again later. ExcelIsFun 456,347 views 1:09:43 Excel 2013 Tutorial: A Comprehensive Guide to Excel for Anyone - Duration: 1:54:45.

JiminSA replied Oct 15, 2016 at 3:37 AM You Tube, Printing, More than... When I press Control+z I get a Microsoft Visual Basic compile error. See your host application documentation for information on including the module in the project. ------------------------------------------------ Excel file is provided by a friend who uses Mac, and I think it contains some If there are any other entries in the Project window at the same level as the VBAProject (Book1) entry then you still have programs opening on startup. -- Rob Bovey, Excel

Stay logged in Sign up now! Uninstalled then reinstalled 8.0. Loading... if the issue goes away, add one back at a time an re-start Excel between each iteration until the issue comes back.

Here are 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 Can you help? No, create an account now. Any help would be much appreciated.

Thanks in advance. also I can't understand, Sheet3 has no subs, so why is data populating into an empty sheet and THEN generating a compile issue (which is what it sounds like)? Dinesh Kumar Takyar 745,811 views 17:20 INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3) - Duration: 1:09:43. Like Show 0 Likes(0) Actions 14.

It's just on this one machine. Deleted PDFMaker.dot and PDFMaker.xla files from both OFFICE11 and XLStart folders 3. Frustrating. If you installed Office to its default location, this will be: C:\Program Files\Microsoft Office\Office\XLStart If you're running Windows 2000 or XP, there's an additional start directory you need to check located

Anything checked there besides (perhaps) Analysis Toolpak? Reply With Quote Oct 5th, 2007,01:05 PM #3 mattach New Member Join Date Oct 2007 Location Seattle Posts 10 Thanks - unfortunately, I did check that and I have no add-ins Compile error in hidden module - Excel Troubleshooting I get an error message: Compile error in hidden module: frm DBLookup with Excel 2002 Any ideas what's causing this???... The error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

What settings do I need to change to enable the Macro to run? Sign in Share More Report Need to report the video? I agree Disagree Register Help Remember Me? If you're not already familiar with forums, watch our Welcome Guide to get started.

If I could rely on a reliable file name, she could put this into her personal.xls file and all would be good in the country. Ask Your Own Question Error - Visual Basic - File Not Found - Excel Excel Forum When I open Excel, I get a standard error box with the heading "Microsoft Visual It not only found the module location itself - C:\Program Files\Microsoft Office\Office12\XLSTART - but found several shortcuts to it in various places. Remove them one by one by unchecking them and restart Excel to see which one it is.

Re: "Compile Error in Hidden Module: Distmon" (Jenny_Kim) Jan 17, 2008 3:58 PM (in response to (dork_92618)) I had this same issue and instead of the STARTUP directory I went into Help provides following info. Edited for size. 7 point type is TOO BIG tjsimons23, Apr 28, 2005 #13 Doug Vitale Joined: Jan 27, 2005 Messages: 148 alexenjen said: I'm getting the following error after Re: "Compile Error in Hidden Module: Distmon" (NLambert) Apr 8, 2008 9:26 AM (in response to (dork_92618)) If you're on a network (at work especially) check with your Administrator to see

In http://www.excelforum.com/showthread...00890#poststop there is a routine that I cannot make work. Advertisement alexenjen Thread Starter Joined: Aug 3, 2000 Messages: 526 I'm getting the following error after opening any office program(s), such as; Word, Excel, Outlook.... Loading...