Google Answers Logo
View Question
 
Q: compile error in hidden module: AutoExecNew ( Answered,   2 Comments )
Question  
Subject: compile error in hidden module: AutoExecNew
Category: Business and Money > Finance
Asked by: jsucla-ga
List Price: $20.00
Posted: 28 Jun 2004 20:15 PDT
Expires: 28 Jul 2004 20:15 PDT
Question ID: 367546
How can I fix this problem that occurs each time I try to open a file
needing to access Excel?
Answer  
Subject: Re: compile error in hidden module: AutoExecNew
Answered By: sublime1-ga on 28 Jun 2004 23:52 PDT
 
jsucla...

According to this Knowledge Base Article from Microsoft,

"This problem can occur when both of the following conditions
 are true:

- The Microsoft Office Startup folder or the Microsoft Excel
  Startup folder contains either (or both) of the following
  Adobe Acrobat PDFMaker add-in template files:

      Pdfmaker.dot
      Pdfmaker.xla
      -and-

- Norton AntiVirus software is installed."
http://support.microsoft.com/default.aspx?scid=kb;en-us;307410&Product=xlw

Instructions given for three workarounds to resolve this
problem include:

- Obtaining the Latest Version of the Adobe Add-in

- Moving these files to a different location.

- Disabling the Norton AntiVirus Office Plug-in


Another page which explores this problem is on ExpertsExchange
and explores a solution for someone who did not have Norton
Antivirus on their system. The author of the solution wrote:

"Have a look for automatically loaded documents.
 (inside the Office-Folder it's .\Startup for Word
 and .\XlStart for Excel)"

"Have a look at the VBA-Editor of any app that's
 causing the error (Press Alt + F11). There, have a
 look at the project-explorer (Ctrl + R).
 Check all projects that are listed there, whether
 some have a module with an AutoExceNew-Sub. If there
 is a project you can't open because of a
 password-protection, you're likely to have found the
 problem."

 "Check out, what it is, correct it or just remove the file."

When the PDFMaker.xla files proved difficult to delete,
another member of the forum suggested:

"1) Exit out of Excel/VBA editor 2) search for PDFMaker.xla
 on your local drive including subfolders, AND before you
 "start" the search indicate that you want to also search
 hidden files (in XP notably). The files are hidden.
 3) In my case there were 4 copies of pdfmaker.xla strewn
 about the place and I deleted them all and Excel works fine"
http://www.experts-exchange.com/Applications/MS_Office/Q_20702796.html


Troubleshooting computer problems at a distance, by its
nature, requires some trial and error, so if what I've
provided does not resolve your problem, or if you need
further elaboration on any of the steps, let me know.

Please do not rate this answer until you are satisfied that  
the answer cannot be improved upon by way of a dialog  
established through the "Request for Clarification" process. 
 
A user's guide on this topic is on skermit-ga's site, here: 
http://www.christopherwu.net/google_answers/answer_guide.html#how_clarify 
 
sublime1-ga


Additional information may be found from an exploration of
the links resulting from the Google searches outlined below.

Searches done, via Google:

"compile error in hidden module: AutoExecNew"
://www.google.com/search?q=%22compile+error+in+hidden+module%3A+AutoExecNew%22
Comments  
Subject: Re: compile error in hidden module: AutoExecNew
From: shibainu-ga on 19 Dec 2004 11:55 PST
 
Perfect answers! Doing the search for the PDF addin was in fact the
problem. I had installed adobe acrobat 6.0 and deleted it, but for
some reason the pdf addin was not taken out, creating the problem with
excel. Once I deleted the addins, all was back to normal. Thanks for
the great answers!
Subject: Re: compile error in hidden module: AutoExecNew
From: sek2005-ga on 22 Jan 2005 15:37 PST
 
Many thanks, it also worked out for me.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy