Microsoft Visual Basic - File not found [PLEASE HELP!!]

[AryehBak]

When I try and open up an Excel workbook (that I really need), I get
"File not found" error (it says "Microsoft Visual Basic" in the blu
line atop the error message). I know that the file exists - I can se
it in Explorer, plus I get the same message when I try and launch th
workbook from a CD-ROM to which I backed it up.

Any ideas whats going on??

Thanks so much,
Aryeh Bak
(e-mail address removed)

 

[Ian]

Is there a VBA routine in the Workbook_Open area that is
trying to reference another excel file which has been
moved.

Try opening the file with macros disabled and see if there
are any such references.

 

[AryehBak]

Thanks for trying to help!

Unfortunately, I have had problems trying to open both with Macro
enabled and disabled.

I've been researching this for the last few hours and haven'
discovered anything concrete, but it looks like the problem could b
somehow related to Tools-Add-Ins. I really don't know any more tha
that, but I'm open to any suggestions or ideas and am grateful for an
help.

I now unchecked all of the add-ins and when I try and open the file
get a different error message. It now states "An error occurre
initializing the VBA libraries (2)" and it says Microsoft Excel in th
blue bar on top of the error message.

Finally, I should note that I have no problem opening other file
(including those that contain macros).

Help?!

Thanks,
Aryeh Bak
(e-mail address removed)

 

[Lady Layla]

1) Go to tools Options General and make sure Ignore other applications is
unchecked

2) try reregistering Excel Go to Start Run and type excel.exe \reg



: Thanks for trying to help!
:
: Unfortunately, I have had problems trying to open both with Macros
: enabled and disabled.
:
: I've been researching this for the last few hours and haven't
: discovered anything concrete, but it looks like the problem could be
: somehow related to Tools-Add-Ins. I really don't know any more than
: that, but I'm open to any suggestions or ideas and am grateful for any
: help.
:
: I now unchecked all of the add-ins and when I try and open the file I
: get a different error message. It now states "An error occurred
: initializing the VBA libraries (2)" and it says Microsoft Excel in the
: blue bar on top of the error message.
:
: Finally, I should note that I have no problem opening other files
: (including those that contain macros).
:
: Help?!
:
: Thanks,
: Aryeh Bak
: (e-mail address removed)
:
:
: ---
:
:

 

[AryehBak]

Have tried both of those already (but THANKS!)

Arye

 

[Dave Peterson]

You could try reregistering excel:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe xl will find those missing VBA libraries.

If that doesn't help, Chip Pearson has some tips on how to find startup problems
at:
http://www.cpearson.com/excel/StartupErrors.htm