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.

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.

ToolsOptionsGeneral 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) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 13:04:00 -0800, rmpete
wrote:

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

Thank you, Gord Dibben

Re-registering Excel removed the problem completely.

Thanks again.

rmpete

"Gord Dibben" wrote:

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.

ToolsOptionsGeneral 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) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 13:04:00 -0800, rmpete
wrote:

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

Thanks for the feedback.

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


Gord



On Sat, 9 Dec 2006 13:56:01 -0800, rmpete
wrote:

Thank you, Gord Dibben

Re-registering Excel removed the problem completely.

Thanks again.

rmpete

"Gord Dibben" wrote:

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.

ToolsOptionsGeneral 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) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 13:04:00 -0800, rmpete
wrote:

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


Gord Dibben MS Excel MVP