Consulting

Results 1 to 3 of 3

Thread: Solved: Compile error in hidden module: distMon

  1. #1
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location

    Solved: Compile error in hidden module: distMon

    Hello Experts,

    somehow my excel problems like to gather on Friday afternoon ...

    I have a complex spreadsheet that works just fine with excel 2000-2003, but when I open it in the new animal excel-2007, I have the warning:

    Compile error in hidden module: distMon

    I saw a couples of information on google but I don't know how to follow the limited instruction on how to fix it. Someone please land a helping hand -- I would greatly appreciate it !!!

    joelle

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Does your code use FileSearch?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location
    Hi xld,

    Not quite sure about your question about code search, but I recently did this and the error msg has gone:

    Go to C:/program files/microsoft office/office11/xlstart
    and delete the "pdfmaker.xla" file there.

    It seems to fix my problem.

    Thanks though.

    joelle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •