File name with spaces Excel 97 & XP

[Al Airone]

We have used Office 97 for about five years and are
continuing to use it with new computers running XP. On
most of these PCs, when you open an Excel file from
Explorer and the filename contains spaces, we get an
error message for each segment of the filename. After
clicking through all of these, the file finally does open.

Anyone else have this problem? It started when we began
using XP (didn't happen with NT or 2000). There is a KB
article (177248) that describes this situation but says
it's due to Excel 4.0 and Excel 97 are installed on the
same PC. This is NOT the case in our case.

We're using Office 97, installed locally, and with SP1
and SP2 installed.

Thanks for any advice/help/info

 

[Gord Dibben]

Al

For paths and filenames with spaces, you have to enter double quotes around
the shortcut.

"C:\your path to Excel\in a folder\somwhere\mybook.xls"

Your Excel file association may be lost.

Start>Run "excel.exe /unregserver"(no quotes and note the space before the /
mark).

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver

If the above steps bring no joy..................

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp>/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

 

[Guest]

Dear Gord -

-----Original Message-----
Al

For paths and filenames with spaces, you have to enter double quotes around
the shortcut.

"C:\your path to Excel\in a folder\somwhere\mybook.xls"

Your Excel file association may be lost.

Start>Run "excel.exe /unregserver"(no quotes and note the space before the /
mark).

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to

Excel\somewhere\excel.exe" /regserver

If the above steps bring no joy..................

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

We have used Office 97 for about five years and are
continuing to use it with new computers running XP. On
most of these PCs, when you open an Excel file from
Explorer and the filename contains spaces, we get an
error message for each segment of the filename. After
clicking through all of these, the file finally does open.

Anyone else have this problem? It started when we began
using XP (didn't happen with NT or 2000). There is a KB
article (177248) that describes this situation but says
it's due to Excel 4.0 and Excel 97 are installed on the
same PC. This is NOT the case in our case.

We're using Office 97, installed locally, and with SP1
and SP2 installed.

Thanks for any advice/help/info

.

 

[Guest]

Dear Gord -

-----Original Message-----
Al

For paths and filenames with spaces, you have to enter double quotes around
the shortcut.

"C:\your path to Excel\in a folder\somwhere\mybook.xls"

Your Excel file association may be lost.

Start>Run "excel.exe /unregserver"(no quotes and note the space before the /
mark).

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to

Excel\somewhere\excel.exe" /regserver

If the above steps bring no joy..................

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

We have used Office 97 for about five years and are
continuing to use it with new computers running XP. On
most of these PCs, when you open an Excel file from
Explorer and the filename contains spaces, we get an
error message for each segment of the filename. After
clicking through all of these, the file finally does open.

Anyone else have this problem? It started when we began
using XP (didn't happen with NT or 2000). There is a KB
article (177248) that describes this situation but says
it's due to Excel 4.0 and Excel 97 are installed on the
same PC. This is NOT the case in our case.

We're using Office 97, installed locally, and with SP1
and SP2 installed.

Thanks for any advice/help/info

.

 

[Al Airone]

Thanks, but no dice. There's no problem with file
association, because double-clicking the file name in
Windows Explorer does start up Excel. And the settings
under File Types match the ones you described.

The mysterious thing is: we never had to put file names
in quotes before (using Win NT or Windows 2000)...yet
using exactly the same procedure the previously worked,
to start an Excel file, is now sensitive to spaces in
file names under XP. (However, there's no such problem
with any other members of the Office suite using XP or
any other recent Windows version).

I appreciate your info but I think I'm still stuck.

-----Original Message-----
Al

For paths and filenames with spaces, you have to enter double quotes around
the shortcut.

"C:\your path to Excel\in a folder\somwhere\mybook.xls"

Your Excel file association may be lost.

Start>Run "excel.exe /unregserver"(no quotes and note the space before the /
mark).

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to

Excel\somewhere\excel.exe" /regserver

If the above steps bring no joy..................

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

We have used Office 97 for about five years and are
continuing to use it with new computers running XP. On
most of these PCs, when you open an Excel file from
Explorer and the filename contains spaces, we get an
error message for each segment of the filename. After
clicking through all of these, the file finally does open.

Anyone else have this problem? It started when we began
using XP (didn't happen with NT or 2000). There is a KB
article (177248) that describes this situation but says
it's due to Excel 4.0 and Excel 97 are installed on the
same PC. This is NOT the case in our case.

We're using Office 97, installed locally, and with SP1
and SP2 installed.

Thanks for any advice/help/info

.

 

[Gord Dibben]

Al

The only fix I know for preventing files with spaces in the names or path
opening as you described in your first post if to use the double quotes around
the full path in the shortcut command line or in file types as I decribed.

Sorry for no further help.

Gord

Thanks, but no dice. There's no problem with file
association, because double-clicking the file name in
Windows Explorer does start up Excel. And the settings
under File Types match the ones you described.

The mysterious thing is: we never had to put file names
in quotes before (using Win NT or Windows 2000)...yet
using exactly the same procedure the previously worked,
to start an Excel file, is now sensitive to spaces in
file names under XP. (However, there's no such problem
with any other members of the Office suite using XP or
any other recent Windows version).

I appreciate your info but I think I'm still stuck.

-----Original Message-----
Al

For paths and filenames with spaces, you have to enter double quotes around
the shortcut.

"C:\your path to Excel\in a folder\somwhere\mybook.xls"

Your Excel file association may be lost.

Start>Run "excel.exe /unregserver"(no quotes and note the space before the /
mark).

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to

Excel\somewhere\excel.exe" /regserver

If the above steps bring no joy..................

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

We have used Office 97 for about five years and are
continuing to use it with new computers running XP. On
most of these PCs, when you open an Excel file from
Explorer and the filename contains spaces, we get an
error message for each segment of the filename. After
clicking through all of these, the file finally does open.

Anyone else have this problem? It started when we began
using XP (didn't happen with NT or 2000). There is a KB
article (177248) that describes this situation but says
it's due to Excel 4.0 and Excel 97 are installed on the
same PC. This is NOT the case in our case.

We're using Office 97, installed locally, and with SP1
and SP2 installed.

Thanks for any advice/help/info

.