Excel error on launch: VB File Not Found

Posted on 2011-10-18
Last Modified: 2012-05-12
Having a weird issues. When I launch Excel 2003 I get a message box stating that states "file not found," the box is titled Microsoft Visual Basic.

My VB code files are all there. Any idea what this might be referring to?
Question by:ThePATMAN26
    LVL 11

    Expert Comment

    Try this Solution I found:
    It's possible that it's looking for your personal.xls workbook. Try this:
    1. Go to: C:\Program Files\Microsoft Office\Office\XLStart\
     and look for the "PERSONAL.xls"
     2. If it isn't there create and save a workbook with that name to that location.
     3. close excel and reopen it.
    If it already is there, and you knew nothing about it prior to this, (i.e. you haven't saved any macros or VBA code to the current personal workbook) delete it and do steps 2 and 3, because it is possible that there are automatic links within the workbook.


    Author Comment

    My personal workbook is there. Is there another file it could be looking for?
    LVL 11

    Accepted Solution

    Did you try deleting your personal workbook?  and replacing it?  

    It's looking for a file, if it's not the personal notebook, try disabling your add ins and then loging in.  If that doesn't work then try and locate a directory like this:

    1.Find your XLSTART folder (On Windows XP it may be a path like this:
     C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART

    If you move all the files out, and then move them back in one by one you should be able to find the offender!

    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

    Join & Write a Comment

    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 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

    23 Experts available now in Live!

    Get 1:1 Help Now