Excel VB Windows XP and 2000 problem

[emrecelebi]

Hi,

i have writen some macros using office 2000 on windows XP and they wor
well. Then i changed my Operating system to windows 2000 and installe
the same office 2000.

When i try to open my excel sheet with both macros enabled and disable
Visiual Basic gives me the "file not found" error in a message box an
nothing more and didnt open the file.

what could be the reason? any idea? i didnt intentially use any dl
from XP but dont know if VB uses them by default!

thanks in advance..

i can provide the excel sheet if anyone want to review... please let m
know.

Emr

 

[Dave Peterson]

When/how does this error show up?

Does it show up when you do a File|open (within Excel) or only if you double
click on file in windows explorer?

If you can open it via File|open (inside xl), then:

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

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.


====
If this didn't help, post back with some more details.

Does it only happen with one workbook or all workbooks?

What do you have checked under Tools|Addins?

In fact, Chip Pearson has a bunch of suggestions to help diagnose problems that
occur when excel starts up.

http://www.cpearson.com/excel/StartupErrors.htm

 

[Travis Box]

Following the K.I.S.S. (Keep It Simple Stupid) methodology of
troubleshooting, the problem may be something as simple as the fact
that you've downgraded the operating system that you're working with.
Close everything out, go to
http://v4.windowsupdate.microsoft.com/en/default.asp to make sure that
your windows 2000 has got all the necessary updates, and then go to
http://office.microsoft.com/OfficeUpdate/default.aspx to make sure
that your version of Office is as updated as it needs to be. Once
you've updated both, it should work fine.