Doesn't find files w/spaces in name

D

Dizzyone

There are a lot of folders and Excel spreadsheets on our shared drive that I
need to open. Most of the folders and file names are named like:
get reports\reports sep 2004.xls

When I try to open one, Excel doesn't find it and I think it's because there
are spaces in the folder names and/or file names. Is there a setting in Excel
that will help me get around this? This was working until I had a glitch in
Excel and the technician fixed the glitch and this problem appeared.

Any help would be appreciated.
 
D

Dizzyone

I found an answer and so far it works. "C:/program files/microsoft
office/Office10/EXCEL.EXE" "%1"
the "%1" was what allowed me to open folders and files with spaces in the
name. I got this from a reply by Jan Karel Pieterse from another question.

1. Open Windows Explorer
2. (Windows XP) choose Tools/Folder Options
3. Select File Types Tab
4, Scrollto Microsoft Excel Worksheet
 
L

Lady Layla

Open Excel

Go to Tools Options General and uncheck Ignore other applications


: There are a lot of folders and Excel spreadsheets on our shared drive that I
: need to open. Most of the folders and file names are named like:
: get reports\reports sep 2004.xls
:
: When I try to open one, Excel doesn't find it and I think it's because there
: are spaces in the folder names and/or file names. Is there a setting in Excel
: that will help me get around this? This was working until I had a glitch in
: Excel and the technician fixed the glitch and this problem appeared.
:
: Any help would be appreciated.
:
 
G

Gord Dibben

Diz

The standard fixes for this problem.......

Tools>Options>General 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) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

One more thing to try if any of the above brings 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
 
Top