Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to be
able to do this. Any help here would be appreciated.

J

Enclose the entire "path name\file name" in double quotation marks.

J wrote:
Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to be
able to do this. Any help here would be appreciated.

J

Right now I'm using the following which has double quotes:

Shell "excel C:\Sample Path\Sample File.xls",
vbMaximizedFocus

Please advise, and thanks for your help!

J

-----Original Message-----
Enclose the entire "path name\file name" in double
quotation marks.

J wrote:
Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to
be
able to do this. Any help here would be appreciated.

J
.

I'm having the same trouble that you did. I'm using this:

Excelstr = "EXCEL.EXE" + " " + Forms![data import]![Viewer Filename]
Call Shell(Excelstr, 1)

The "Viewer Filename" is a path that has spaces in it and excel cuts off the
path wherever there is a space and tries to open a file. If there are two
spaces in the path, ie C:\Data from Calgary.xls is interpreted as
C:\Data.xls, from.xls, and Calgary.xls. Did you ever figure this out?




"J" wrote:

Right now I'm using the following which has double quotes:

Shell "excel C:\Sample Path\Sample File.xls",
vbMaximizedFocus

Please advise, and thanks for your help!

J

-----Original Message-----
Enclose the entire "path name\file name" in double
quotation marks.

J wrote:
Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to
be
able to do this. Any help here would be appreciated.

J
.

Did you try enclosing in double quotes. If you have quotes enclosed
then you have to double the enclosed quotes.

Another thing to try would be to use %20 instead of the space
for within the pathname.
filename = Replace(filename, " ", "%20")
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"t.roff" wrote in message ...
I'm having the same trouble that you did. I'm using this:

Excelstr = "EXCEL.EXE" + " " + Forms![data import]![Viewer Filename]
Call Shell(Excelstr, 1)

The "Viewer Filename" is a path that has spaces in it and excel cuts off the
path wherever there is a space and tries to open a file. If there are two
spaces in the path, ie C:\Data from Calgary.xls is interpreted as
C:\Data.xls, from.xls, and Calgary.xls. Did you ever figure this out?




"J" wrote:

Right now I'm using the following which has double quotes:

Shell "excel C:\Sample Path\Sample File.xls",
vbMaximizedFocus

Please advise, and thanks for your help!

J

-----Original Message-----
Enclose the entire "path name\file name" in double
quotation marks.

J wrote:
Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to
be
able to do this. Any help here would be appreciated.

J
.

Thanks! I was trying to put double quotations in the code, but what worked
was to put double quotes around the pathname in the form.

"David McRitchie" wrote:

Did you try enclosing in double quotes. If you have quotes enclosed
then you have to double the enclosed quotes.

Another thing to try would be to use %20 instead of the space
for within the pathname.
filename = Replace(filename, " ", "%20")
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"t.roff" wrote in message ...
I'm having the same trouble that you did. I'm using this:

Excelstr = "EXCEL.EXE" + " " + Forms![data import]![Viewer Filename]
Call Shell(Excelstr, 1)

The "Viewer Filename" is a path that has spaces in it and excel cuts off the
path wherever there is a space and tries to open a file. If there are two
spaces in the path, ie C:\Data from Calgary.xls is interpreted as
C:\Data.xls, from.xls, and Calgary.xls. Did you ever figure this out?




"J" wrote:

Right now I'm using the following which has double quotes:

Shell "excel C:\Sample Path\Sample File.xls",
vbMaximizedFocus

Please advise, and thanks for your help!

J

-----Original Message-----
Enclose the entire "path name\file name" in double
quotation marks.

J wrote:
Greetings All

I'm having trouble opening files (of any type) which
contain spaces in the path and/or filename. I'd like to
be
able to do this. Any help here would be appreciated.

J
.