excel 2010 compile error in hidden module distmon Clarkson New York

Remote Support, Cloud Computing, On Site Support, Computer Optimization

Address 20 Coyote Run, Spencerport, NY 14559
Phone (585) 617-4398
Website Link http://technologysimplified.biz
Hours

excel 2010 compile error in hidden module distmon Clarkson, New York

Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions More Like This Retrieving data ... © 2016 Adobe Systems Incorporated. It's just on this one machine. How do I get rid of ThisWorkbook1? Please enter a title.

under C:\Documents and Settings\...\Excel\etc\ as hinted in the above posts. Then, I found the "pdfmaker.xla" file in C:/program files/microsoft office/office11/xlstart and deleted it (also deleted one in ../recent but I don't know if it matters. (I may have an error in Regards, peo sjoblom "Lloyd" wrote: > My company currently uses Office XP SP2 and Project 2000 SR1. would think Adobe would have their act together by now and done some decent testing before release so their tech support people were prepared for the inevitable...

In the Look In box, click the C drive and then click Search Now.

The Pdfmaker.dot file is located in one of the following folders: C:\Program Files\Microsoft Office\Office\Startup (Word 2000) Long story short the tech dept did not have the answer and after an hour of troublshooting he said it was an issue with MS. However, note that this will only delete Delete Hidden Worksheets - This macro will delete all hidden worksheets within a workbook. finally someone was able to help me.

Anyone got any ideas on what might be the problem here? Many times the error messages are not clear as to what the cause of the problem is and you will have to do some research to see if you can fine Please try the request again. Maybe it's just a syntax problem?

I seached my C: drive, found the PDFMaker.xla file, deleted it, and Excel 2003 works without the error messages at opening and closing. I tried to speed up my computer by removing some programs. Reply John Freeman says: October 13, 2008 at 1:42 pm After deleting the XLStart folder in Program files/Microsoft Office/Office12 and doing a search for all PDFMaker files and deleting them, I The odd thing is it's only doing this with one profile on the computer.

I've closed every single open module but the one I'm working with and it still does it. Reply Jesal says: November 19, 2010 at 7:11 am Thanks - did the trick :) Reply Rick Malamed says: September 24, 2010 at 2:50 am I found PDFMarker.xla in several locations Ask Your Own Question Can't Access Phstat2 2.8.1 - Excel Excel Forum Hello there. Reply Anonymous says: July 7, 2011 at 11:33 pm I had the same problem.

Reply vtyk says: October 2, 2009 at 4:38 pm Thank you for your tip Reply Patrick says: September 22, 2009 at 4:12 pm Julie, you probably just deleted a shortcut. This error has the following cause and solution: There is a compilation error in the code of the specified module, but it can't be displayed because the project is protected. Your cache administrator is webmaster. This error has the following cause and solution: There is a compilation error in the code of the specified module, but it can't be displayed because the project is protected.

Adobe WAKE UP ! I did the search for both types of files (*.xla and *.dot) and the return shows the files, BUT someone had already renamed the files (pdfmaker.xla to pdfmaker.old.xla and pdfmaker.dot to Anyone have any ideas on how I can fix this PC?Thanks(Quote) Reply Irvin says: July 14, 2010 at 3:43 pm Linda Reed: I have had this issue on several of the My theory is that if the module is in the actual employee file, I don't need the file name to do the manipulations required.

I don't have access to 2007 so I can't begin to figure this out TIA Ask Your Own Question "compile Error In Hidden Module: Module1" - Excel Excel Forum hi all, I deleted both and the hash of distmon has been settled once and for all. Re: "Compile Error in Hidden Module: Distmon" (Trent_Ridder) May 23, 2007 7:21 AM (in response to (dork_92618)) I also had a similar problem, but found that my pdfmaker.dot and pdfmaker.xla files It comes up with "Visual Basic" error window, and the error message is "Module not found".

Thank you for the posting. Linda Reed: I have had this issue on several of the PC’s in our office and have resolved the problem following the advice above (thank you very much!). For example, the statement MyModule.SomeVar = 5 generates this error when MyModule isn't visible in the project MyProject. Re: "Compile Error in Hidden Module: Distmon" (David_A_Smith_PE) Apr 12, 2007 7:50 PM (in response to (dork_92618)) I had the same problem and could not find the PDFMaker.xla until I checked

Insert -> Module 2. I did the search for both types of files (*.xla and *.dot) and the return shows the files, BUT someone had already renamed the files (pdfmaker.xla to pdfmaker.old.xla and pdfmaker.dot to Under Tools > References, the following are checked: Visual Basic for Applications, Microsoft Excel 9.0 Object Library, OLE Automation, & Microsoft Office 9.0 Object Library. 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.

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. Пропустить I did the Repair option under the help menu but, that wasn't the cure. Unprotect the project, and then run the code again to view the error." Any ideas how to solve it? Casey noted above.

Is it something to do with the version of excel i was previously using 2000 but now using 2003 with sp3?? Reply PaulC says: February 21, 2009 at 9:16 am No files names PDFMaker.xla, hidden or otherwise so nothing to delete. under C:\Program Files\etc\ 2. Removing PDFMaker.xla from the profile directory seems to have eliminated the message.

Re: "Compile Error in Hidden Module: Distmon" (Ronnie_Pincus) May 7, 2007 12:24 AM (in response to (dork_92618)) Well, on next boot the same error message appeared. Sub AddFY() 'code Call SummaryUpdate End Sub I'm getting the following error... "Compile error: Expected variable or procedure, not module" Thoughts??? This is the first step to learning about Macros for Excel and how to use them. I went through the installed repair procedure with Adobe 8 Standard and the error finally disappeared.

I've checked with them their add ins - they seem to have the same as me, and their macro security is the same, any ideas why i can view it but 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 This may impact how PDFs are displayed... Your advice worked like a charm.

Reply Mandi says: June 10, 2011 at 12:34 am Thanks so much for the help, i have been having this problem for so long, i didn't think there was a way I then did two things: First, under the control panel, Add/Remove Programs, I removed "acrobat 6.0 upgrade" which did not seem to be removed automatically by the 8.0 installer.