[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel error on launch: VB File Not Found

Posted on 2011-10-18
3
Medium Priority
?
214 Views
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?
0
Comment
Question by:ThePATMAN26
  • 2
3 Comments
 
LVL 11

Expert Comment

by:ScriptAddict
ID: 36986666
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.
 

0
 

Author Comment

by:ThePATMAN26
ID: 36987688
My personal workbook is there. Is there another file it could be looking for?
0
 
LVL 11

Accepted Solution

by:
ScriptAddict earned 2000 total points
ID: 36987956
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!
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

873 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