Re: File name with spaces Excel 97 & XP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Al Airone (anonymous_at_discussions.microsoft.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 13:11:37 -0800

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
>Work***. 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
>
>On Thu, 18 Mar 2004 07:32:47 -0800, "Al Airone"
><anonymous@discussions.microsoft.com> wrote:
>
>>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
>>
>
>.
>

Quantcast