Good afternoon,

I'm using code to display a folder structure, from which i can click on a
folder and store it to a variable name.
I then want to save the current workbook into that folder, but I don't seem
to be able to use the CHDIR command without the parametr being in
parentheses. I want to say something line CHDIR(MySelectedFolder), but the
Help only shows examples like CHDIR "C:\MyFolder". Is it possible to do what
I want?
Thanks in advance
Pete

CHDIR MySelectedFolder

should work.

--
Jim
"Pete Rooney" <(E-Mail Removed)> wrote in message
news:B1A68F76-B3D9-45A0-BF35-(E-Mail Removed)...
| Good afternoon,
|
| I'm using code to display a folder structure, from which i can click on a
| folder and store it to a variable name.
| I then want to save the current workbook into that folder, but I don't
seem
| to be able to use the CHDIR command without the parametr being in
| parentheses. I want to say something line CHDIR(MySelectedFolder), but the
| Help only shows examples like CHDIR "C:\MyFolder". Is it possible to do
what
| I want?
| Thanks in advance
| Pete

Jim,

I must have been having a bad hair day - all working now! :-)

Cheers

Pete



"Jim Rech" wrote:

> CHDIR MySelectedFolder
>
> should work.
>
> --
> Jim
> "Pete Rooney" <(E-Mail Removed)> wrote in message
> news:B1A68F76-B3D9-45A0-BF35-(E-Mail Removed)...
> | Good afternoon,
> |
> | I'm using code to display a folder structure, from which i can click on a
> | folder and store it to a variable name.
> | I then want to save the current workbook into that folder, but I don't
> seem
> | to be able to use the CHDIR command without the parametr being in
> | parentheses. I want to say something line CHDIR(MySelectedFolder), but the
> | Help only shows examples like CHDIR "C:\MyFolder". Is it possible to do
> what
> | I want?
> | Thanks in advance
> | Pete
>
>
>