Files with ^Spaces^ in the path or name won't open...

  • Thread starter Thread starter rjenkin9
  • Start date Start date
R

rjenkin9

When I doubleclick on a file that has a space in it's name or a space at
some point in the path it will not open properly in Excel...

for a file with the following path
'c:\WINNT\Profiles\rjenkin9\Desktop\Person\File Name.xls. Excel
gives the following message:
'c:\WINNT\Profiles\rjenkin9\Desktop\Person\File.xls could not be found.
Check the spelling of the file name, and verify that the file location
is correct. If you are trying to open the file from your list of most
recently used files on the File menu, make sure that the file has not
been renamed, moved, or deleted.

If I hit OK on that message another message pops up with the remainder
of the file name after the space... 'Name.xls' could not be found.
Check the spelling...

This happens for any file that has a space in either the name, or at
some point in the path...



------------------------------------------------




------------------------------------------------
 
You need double quotes around the path.

"C:\the path\to excel\the file.xls"

Re-registering Excel usually takes care of this.

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

Gord Dibben Excel MVP XL2002
 
Back
Top