Compile Error in Hidden Module: Excel 2007

I'm receiving an error when Excel 2007 opens
'Compile Error in Hidden Module: AutoExecNew'
and an error when Excel 2007 closes
'Compile Error in Hidden Module: DistMon'
Microsoft knowledge base says to look for two Adobe files
and delete them out of the startup folder; however, I don't see them in the folder.
Any suggestons?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
There are two XLSTART folders. One in the MS Office installation directory - something like C:\Program Files\Microsoft Office\Office12 - and the other in your C:\Documents and Settings\*username*\Application Data\Microsoft\Excel directory. The latter is usually a hidden directory so you may need to go into Windows Explorer, and select Tools-Folder Options and on the View tab, click the Show hidden files and folders option.
You can also locate the xla via a search as long as you select the option to include hidden files and folders.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

Did you check the Windows startup folder or the Excel startup folder?

The Excel startup folder should be found at the following path.

C:\Program Files\Microsoft Office\OFFICE12\XLSTART

Kindest Regards,

We got "compile error in hidden module" in the past when there were files or libraries disabled by the application.

Go in Excel
- Help
- About Microsoft Exce (at the bottom)
- Disabled items

If there are items in the list, you can enable them, and your problem can be solved.

CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.


I completely forgot about the Application Data XLSTART folder.  :)

Rory ArchibaldCommented:
I usually forget about the Program Files one! I should also have pointed out that you can set an additional startup folder in the Excel options, but I've never (yet) seen the PDFMaker.xla install itself in there!

I personally use an alternate XLSTART folder that I created in My Documents\My Excel\XLSTART so that everything gets backed up when I back up My Documents.  AS for PDFMaker, I wrote my own custom Excel PDF Maker in Excel VBA since I didn't know anything was available elsewhere.  ;)

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Acrobat

From novice to tech pro — start learning today.