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

P

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with file path to sharepoint 0
Chdir does not seem to change the current directory -- ?? 5
Confusion over where user templates are stored in Word 1
Another Question about Save As Dialog box 3
ChDir and ChDrive 2
OPEN WORKBOOK 3
Open a workbook from within a specified folder 4
Make Variable Range in VBA 6

Top