Shell function has a path with embedded blanks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug F. - 15 Dec 2005 00:25 GMT

I use the Shell function to zip a file. The directory path to the input file
contains embedded blanks in the name. I can't change the name. So, how can I
hard code this path? eg H:\"My directory"\ doesn't work. Thanks.

Signature

Doug F.

Reply to this Message

Branden Johnson - 15 Dec 2005 03:49 GMT

Try using Chr(34) in place of your double quotes like this:

strMyPath = "H:\" & Chr(34) & "My directory" & Chr(34) & "\"

Branden Johnson

> I use the Shell function to zip a file. The directory path to the input file
> contains embedded blanks in the name. I can't change the name. So, how can I
> hard code this path? eg H:\"My directory"\ doesn't work. Thanks.
>
> --
> Doug F.

Reply to this Message

Tom Lake - 15 Dec 2005 04:18 GMT

> Try using Chr(34) in place of your double quotes like this:
>
> strMyPath = "H:\" & Chr(34) & "My directory" & Chr(34) & "\"

The quotes should be around the entire path name rather than just the
directory name

Try

strMyPath = """H:\" & "My directory" & "\"""

Tom Lake

Reply to this Message

Doug F. - 15 Dec 2005 20:48 GMT

Thanks, I tried quotes around the entire path first, it works fine.

Signature

Doug F.

> > Try using Chr(34) in place of your double quotes like this:
> >
[quoted text clipped - 8 lines]
>
> Tom Lake

Reply to this Message