Compile Error in Hidden Module: Excel 2007

Posted on 2007-07-23
Last Modified: 2012-05-05
I have researched the problem with "Compile Error in Hidden Module: Excel 2007" and have tried the suggestions listed here and I did find the pdfmaker.xls, cut and pasted it to the My docs" folder.  Now a week later the error was returned. Office 2007 and Adobe 8 are running on a XP Pro 64 edition.

Any new suggestions on how to stop this annoying error when opening Excel or closing it???
Question by:bigblue72
    LVL 85

    Expert Comment

    by:Rory Archibald
    Check both your XLSTART directories - one in C:\Documents and settings\username\application data\microsoft\excel and one in C:\program files\microsoft office\office12 - for files (particularly see if PDFMaker has resurfaced) and also check in the add-ins section under Excel Options to see what is loaded.

    Author Comment

    I have checked both places and have nopt been able to locate pdfmaker and I have already made sure that all hidden files for visible?
    LVL 85

    Accepted Solution

    It's a compile error in a file that is loading at startup - either personal.xls or an add-in. Try disabling all add-ins and see if that cures it. Also check under Excel Options, in the Advanced section there is an option under General for an alternate startup folder. If there is one specified, check for any files located in that folder.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    PDF files have been in the limelight due to its unmatched features.  Personal documents, emails, business reports and eBooks are all converted into PDF files owing to peerless features provided by it. Adding watermark to a PDF file is a method to se…
    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now