Re: File name with spaces Excel 97 & XP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 03/18/04 

Date: Thu, 18 Mar 2004 13:04:39 -0800

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
(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
>>
>
>.
>

Relevant Pages

  • Re: File name with spaces Excel 97 & XP
    ... For paths and filenames with spaces, you have to enter double quotes around ... Your Excel file association may be lost. ... Then if running Win98 OS Edit> select "Open" and Edit. ... >error message for each segment of the filename. ...
    (microsoft.public.excel.misc)
  • Re: Macro to change linked object source file
    ... "test.xls"', using whatever the real filename is, minus the path. ... [MVP - Microsoft Word] ... original excel file name in the item section of the linked object. ...
    (microsoft.public.word.vba.general)
  • Re: File name with spaces Excel 97 & XP
    ... >Your Excel file association may be lost. ... >You must have the double quotes. ... >>error message for each segment of the filename. ...
    (microsoft.public.excel.misc)
  • textbook problems on H I/O (beginner)
    ... filename is given as an input to this function in csv1. ... Write the resultant array to the filename ... that is given as an input to this function in csv2 as a csv file. ... Read in an Excel file whose filename is ...
    (comp.soft-sys.matlab)
  • Re: gui/excel/array
    ... select an excel file. ... filesep is a function that returns the appropriate file seperator. ... FileName) ... To put the filename into the array, or to put the data into ...
    (comp.soft-sys.matlab)