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
.