Changing the folder to a value stored in a variable instead of a s

[Pete Rooney]

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 Rech]

CHDIR MySelectedFolder

should work.

--
Jim
| 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

 

[Pete Rooney]

Jim,

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

Cheers

Pete