Setting a path to a folder

[Boots]

I have created a macro that checks if a folder is present and if it isn't it
creates it. The macro continues to save the active workbook. The creation
of the folder works great but the the workbook is being saved in mydocuments
rather than the folder created. How do I code to save it in the folder
created?
I'm pretty sure it just involves setting the path but i'm not sure on the
syntax

thanks in advance

[Boots]

I've solved it using chdir

"Boots" wrote:

> I have created a macro that checks if a folder is present and if it isn't it
> creates it. The macro continues to save the active workbook. The creation
> of the folder works great but the the workbook is being saved in mydocuments
> rather than the folder created. How do I code to save it in the folder
> created?
> I'm pretty sure it just involves setting the path but i'm not sure on the
> syntax
>
> thanks in advance

[Bob Phillips]

Something like

Activeworkbook.SaveAs myPath & "\" & myFilename

where myPath is the path you checked/created.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Boots" <[email protected]> wrote in message
news:[email protected]...
> I have created a macro that checks if a folder is present and if it isn't
it
> creates it. The macro continues to save the active workbook. The
creation
> of the folder works great but the the workbook is being saved in
mydocuments
> rather than the folder created. How do I code to save it in the folder
> created?
> I'm pretty sure it just involves setting the path but i'm not sure on the
> syntax
>
> thanks in advance