Excel filename with spaces causes errors

[PDS]

Hi

I hope someone can help me.

I have a user that has her documents (.xls) stored on a network share.

The filenames has spaces between them ( eg. John Higgins Private
Worksheet.xls ) , and now when she double clicks on the file, Excel starts
to open and then gives an error that it cannot find the files, but these
"other" files are acctually the the rest of the name of the document - it
gives the error for each word after the space

It's as if it treats the spaces as an end to the file :

It then says :

Cannot find John.xls.....blah blah blah !!!
Cannot find Higgins.xls ....blah blah blah!
Cannot find Private.xls........
Cannot find Worksheet.xls .... and so on

Any idea what the fix is ?

Thanks

Pieter

[Jimmy L. Day]

I believe you can access the files names in Explorer, right click them (one at
a time) and re-name them. better yet, let the user do it!

[Gord Dibben]

PDS

In Explorer go to View>Folder Options>File Types and scroll down to
Microsoft Excel Worksheet and Edit. Select Open in dialog box then
Edit again. In command make sure you/she has quotes ("") around the
command line.

i.e. "C:\program files\microsoft office\office\excel.exe"

HTH Gord

[Myrna Larson]

On Thu, 14 Dec 2000 12:24:42 -0800, Gord Dibben <gdi...@home.com> wrote:

You're on the right track, Gord, but it isn't the command line that's the
problem. You need to be sure that "Use DDE" is checked, and in the "DDE
message" box, you must have quotes around the FILE NAME, i.e. it should look
like this.

[open("%1")]

[Gord Dibben]

Thanks Myrna

Goofed again. Sorry PDS. Listen to Myrna.

Gord