Remove all instances of the PDFMaker.dot and PDFMaker.xla files from \Program Files\Microsoft Office\Office version/Startup folder and reinstall PDFMaker using the Help > Detect and Repair menu option in Acrobat.
So, apparently Adobe isn't talking on this at all..... 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. I can get fine PDFCreators from several sites around the world, and they all work fine. Acrobat 8 Pro cost us some money, and has some great features, but if we can't get this resolved, we will downgrade and begin looking elsewhere.
I got the same error (..Compile error.. DISTMON) when launching XL. I'm running Office 2007 and recently upgraded Acrobat 6.0 to 8.0, which I believe caused the error.
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.
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 my recollection here, it might have been in the folder OFFICE12 instead of OFFICE11 but neither any longer has an .XLA file in it (they are completely empty).)
Then, I reinstalled the 8.0 DVD and selected "INSTALL" and "REPAIR". I then waited patiently about 15 minutes for the install and...
I had the same problem and could not find the PDFMaker.xla until I checked the search box under advanced to look for hidden files and folders as B. Casey noted above. I found two of the files under documents and settings. After I deleted them the problem with XL went away. I then did detect and repair and it is still ok.
I called Adobe first for support... Actually I opened a web case first with the Customer Service section and they replied and said to contact Tesh Support. I opened a web case with Tech Support and they replied and said to contact Customer Service so that's when I called.
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. I didn't buy that answer.
The above worked and it seems to be an Adobe issue not MS - maybe the Adobe tech team should have someone checking the forums so they can update their knowledge tree.
I also upgraded to Adobe Acrobat 8 over Microsoft Office 2007. I just removed the file:Program Files/Microsoft Office/Office12\XLSTART and that completely resolved the problem - no need for any other action.
I remember this happening a few years ago upgrading to Acrobat 5? 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...
I am having the same problem today. Not having any luck though trying the suggestions here. I first did a search for the two files PDFMaker.dot and PDFMaker.xla They do not exist, have hidden files to show.
I've tried both Adobe 8.0 and Office XP repair. That didn't make any difference. Uninstalled then reinstalled 8.0. No difference.
The odd thing is it's only doing this with one profile on the computer. Tried all of these with the different profiles, still didn't help.
Well, on next boot the same error message appeared. I tried deleting the empty XLStart folder (instead of renaming), but it didn't help.
Sorry for any false hope. I did send an email to Adobe Tech Support, but I'm not very hopeful.
YAY! I followed Robert Caspe's instructions (with the following exceptions) and it worked. THANKS, my brain won't explode now!
1. Didn't remove "acrobat 6 upgrade" (don't even know if it's there)
2. Deleted PDFMaker.dot and PDFMaker.xla files from both OFFICE11 and XLStart folders
3. Didn't reinstall 8.0, just opened it and went to Help/Repair Adobe Reader Installation. It took about 45 seconds.
I also had a similar problem, but found that my pdfmaker.dot and pdfmaker.xla files were not in the program files tree. Instead they resided in the documents and settings tree, with one instance in every user account on the computer.
Removing them all and performing the repair option as above cured the error.
I deleted these two files and it worked:<br /><br />C:Documents and Settings\<user>\Application Data\Microsoft\Excel\XLSTART\PDFMaker.xla<br /><br />C:Documents and Settings\<user>\Application Data\Microsoft\Office\Recent\PDFMaker.xla.LNK<br /><br />--jsh
I recently upgraded to Acrobat 8 from Ac 6 and started getting "compile error...distmon" everytime I launched or closed Excel(MS Office 2003). Google pointers to MS, Symantec, and Adobe support pages were useless. Then I landed on this page, did a search on C: for pdfmaker.xla, found 2 copies, and deleted both. Error message is now gone and the convert xls file to pdf button in Excel still works. No need to reinstall or repair Adobe 8. Thanks everyone for your posts!
I deleted c:\program files\adobe\acrobat 8.0\pdfmaker\office\PDFMExcel.dll and c:\documents and settings\user\application data\microsoft\office\recent then restarted Excel and it ran through a self installer and worked fine with no error. I closed it and reopened to make sure it was fixed and there was no further error. Thanks for all the input everyone.
For those unsuccessful with the above solutions, pls try to locate and delete the following files:
C:\Documents and Settings\[user name]\Application Data\Microsoft\Excel\pdfmaker.xla, and/or
C:\Documents and Settings\[user name]\Application Data\Microsoft\Word\pdfmaker.dot
Correction - the correct passes are as follows:
C:\Documents and Settings\[user name]\Application Data\Microsoft\Excel\XLSTART\pdfmaker.xla, and/or
C:\Documents and Settings\[user name]\Application Data\Microsoft\Word\STARTUP\pdfmaker.dot
I tried all the fixes without success until I realised that there were two instances of the file pdfmaker.xla
1. under C:\Program Files\etc\
2. under C:\Documents and Settings\...\Excel\etc\
as hinted in the above posts. I deleted both and the hash of distmon has been settled once and for all.
The main question is: "Why do I find this error so annoying and spend stupid time trying to fix it?" Zeigarnik?
\\machine\c$\Documents and Settings\kristo marinoff\Application Data\Microsoft\Office\Recent\pdfmaker.xla.lnk and
\\kmachine\c$\Documents and Settings\kristo marinoff\Application Data\Microsoft\Excel\pdfmaker.xla
... just as jhooda mentioned, and voila!
Also removed the acrobat 6 update but just to keep the workstation clean.
I recently purchased a new lap top and transferred some files from my old one - I began getting the "Compile Error: DISTMON" whenever I tried to access any .xls files. Thanks to my Brother (who suggested I check this site) and the advice posted above I solved the problem. I deleted the pdfmaker.xla file and Adobe 6.0. The new laptop already had Adobe 8.0 installed. Many thanks on solving this extremely aggravating problem.
Very nervous computer-user here - sorry if I'm in the wrong place but the problems seem to be related. I tried to speed up my computer by removing some programs. I took out Adobe 5.0, I think it was, because I've got Adobe Acrobat 6.0 and Adobe Reader 7.0. But now when I open or close a Word file, i get this message: "Compile error in hidden module: AutoExec." I've searched for the .dot and .xla files but can't find any. When I click 'help' it says "A protected module can't be displayed. 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. Unprotect the project, and then run the code again to view the error." This means nothing to me...
I don't know what to do - this is beyond my usual simple computer use, plus I work writing from home so don't have any tech support. This stuff makes me fear my own computer! Thanks in advance
If you uninstall Acrobat or Reader it will damage whatever is left -
so don't do that! Since you did do that, reinstall the other ones.
Note that Adobe do not recommend having both Acrobat and Reader
Thanks so much for your answer, Aandi. I'm still confused though. What should I reinstall? I've still got Adobe Acrobat 6.0 Professional and Adobe Shockwave Player. And should I remove Reader 7.0.9 altogether if it's not a good idea to have both Acrobat and Reader? Whatever is on here came with the computer when I got it last year. Thanks, Tamsin
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 do that before uninstalling! Note
that you will need the original Acrobat serial number printed on the
I had this same issue and instead of the STARTUP directory I went into the XLSTART found in my C:\Program Files\Microsoft Office\Office12\XLSTART (this may vary depending on where you installed Office. The was a Adobe Template file in this directory. I removed it and it fixed the issue.
My environment is Office Pro 2007 and Adobe Acrobat 8 Standard under XP Pro SP2.
I tried all the above methods, to no avail. For some reason it kept finding the module and posting the error - both at startup and again at shutdown. I did not delete the module, but rather renamed it, once with a .rmv extension, then another time with rmv as the prefix for the name. I've been bit removing things before, and have learned to rename instead of delete.
Here's what worked for me:
Starting at C:, I searched for "pdfmaker" - without the xla extension. It not only found the module location itself - C:\Program Files\Microsoft Office\Office12\XLSTART - but found several shortcuts to it in various places.
I moved the module from it's location out to my desktop, then deleted all the shortcuts I found.
I went through the installed repair procedure with Adobe 8 Standard and the error finally disappeared.
Thanks to the forum for identifying the module.
Hope this helps someone else.
My installation of Acrobat Pro 6.0 hangs when it can't find the file PDFX1aSet_PSR_ gravure.pdf. Any ideas about how to fix?
- Acrobat was running fine (as would have the install CD, I believe) until I removed Acrobat due to an unrelated issue using the Windows Install Cleanup program.
- I've uninstalled and reinstalled Reader 8.0; no effect
- The error is also temporally related to getting the following error when opening and closing Excel: "..compile error.. autoexecnew," then "distmon," respectively. I attempted this solution, but failed:
- I've uninstalled and reinstalled Office 2003; run repair w/in Excel; no effect
- In Internet Explorer, I can open a PDF successfully, but the following error also appears: "One or more Adobe PDF extensions are disabled. This may impact how PDFs are displayed... enable add-ons [in IE]." However, all the Adobe add-ons are already enabled in IE.