my.xls

[Guest]

When I try to launch C:\My Documents\06-RateData.xls in Excel 97,
I get a screen that says " 'C:\My.xls' could not be found. ..."
After I hit OK this is followed by a screen that says "
'Documents\06-RateData.xls' could not be found ..."
and after I hit OK again 06-RateData.xls opens and everything seems normal;
all of my macros are available.
I cannot find C:\My.xls on my hard drive or in the Recycle Bin, and I don't
know what it is.
Ths same thing happens whenever I try to open any other Excel 97 file.
But once Excel is open, the problem disappears and I can then open any *.xls
file normally.
What do I have here, and how do I get rid of it?
Thanks in advance.

 

[Gord Dibben]

The error has to do with the spaces in the pathname.

Note you get an error at each space.

Try the usual fix(es) for this problem.

Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.


Gord Dibben MS Excel MVP

When I try to launch C:\My Documents\06-RateData.xls in Excel 97,
I get a screen that says " 'C:\My.xls' could not be found. ..."
After I hit OK this is followed by a screen that says "
'Documents\06-RateData.xls' could not be found ..."
and after I hit OK again 06-RateData.xls opens and everything seems normal;
all of my macros are available.
I cannot find C:\My.xls on my hard drive or in the Recycle Bin, and I don't
know what it is.
Ths same thing happens whenever I try to open any other Excel 97 file.
But once Excel is open, the problem disappears and I can then open any *.xls
file normally.
What do I have here, and how do I get rid of it?
Thanks in advance.

Gord Dibben MS Excel MVP

 

[Guest]

Thank you, Gord Dibben

Re-registering Excel removed the problem completely.

Thanks again.

rmpete

 

[Gord Dibben]

Thanks for the feedback.

What the re-register does is place quotes around the command line so the spaces
are ignored.


Gord

Thank you, Gord Dibben

Re-registering Excel removed the problem completely.

Thanks again.

rmpete

Gord Dibben MS Excel MVP