Opening or saving in Excel 2003 gives VB Compile Error


G

Guest

Upon starting Excel 2003, trying to open a file, or trying to save a file, I
keep getting a Visual Basic Compile Error message. Usually it says "can't
find project of library". I can close VB and work the spreadsheet, but if I
try to save, again I get the VB error. Any suggestions?
 
Ad

Advertisements

J

Jan Karel Pieterse

Hi Rcktredglare,
Upon starting Excel 2003, trying to open a file, or trying to save a file, I
keep getting a Visual Basic Compile Error message. Usually it says "can't
find project of library". I can close VB and work the spreadsheet, but if I
try to save, again I get the VB error.

It is very likely an add-in is bothering you. Open Tools, Add-ins and note
which are checked. Uncheck one-by-one (closing the dialog afterwards) and try
to save to see if the problem goes away, Then you'll know which one is the
culprit.

If that doesn't help:

Find your XLSTART folder (On Windows XP it may be a path like this:
C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART
Move all files out of it;
Open them one by one (in Excel) and find the one with the error;
Move the others back.
Repeat the above for the folder listed in Tools, Options, General, "Alternate
Startup file location" or "At startup, open all Files in:" (The text depends on
your version of Excel).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top