Opening applications (Microsoft Excel specifically) generating Visual Basic compile error.

pts.
Tags:
Windows XP
I have an interesting problem with an application. When I double click a spreadsheet to open it, it open the application, but not the spreadsheet, and gives me this error. Visual Basic complie error in module autoexecnew. I can then click on file...open...and open the spreadsheet, but it won't open the app and the file at the same time. Upon closing the app I get the message: Visual Basic compile error in module diskmon. I'm thinking this is a problem with XP because I've completely removed and reinstalled the app, no help. Also, the fact that the file will open if you start with the app open leads me to the OS also. I don't understand why I would get a VB error!?!? Has anyone ever seen anything even close to this? My next thought was to reimage the hard drive, but want to avoid that if possible. Please help! Thanks, Russ

Answer Wiki

Thanks. We'll let you know when a new response is added.

I have seen this several times.

Macros – Check the autoload/startup for Microsoft Excel.
(Open Excel – Tools Menu – look at Add-ins & Macros)

Probably a macro setup as default under a previous version of Excel. New versions of Excel ‘protect’ you from macros that would run automatically. You double click the spreadsheet – Excel throws an exception – the error message and file open aborts while you deal with the message. If Excel is already open the file will open an does not error becausee the the macro/addin has already been dealt with when you started Excel. The give away is the error on exit.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BinooDas1234
    I agree with Howard2nd.. If you are using Office 2003 and the above doesn't solve your problem, try the following... 1) Go to Help-->About MS Excel-->Disabled Items-->Enable all the items there 2) Go to Help-->Detect and Repair Hope this helps.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following