How do I use a macro to save to a specific drive in Excel?

I wrote a macro in excel to facilitate creating monthly reports. I want it
to save to a new folder each month (ie. the current monthly folder), but I am
not sure how to write a changing "save as" formula.

Something along the lines of :

Thisworkbook.SaveAs "C:\RootFolder\" & Format(Date,"yyyymmm") &
"\Basename.xls"

might give you some ideas.
--
Regards,
Tom Ogilvy

"Meredith" <[email protected]> wrote in message
news:[email protected]...
> I wrote a macro in excel to facilitate creating monthly reports. I want
it
> to save to a new folder each month (ie. the current monthly folder), but I
am
> not sure how to write a changing "save as" formula.

hi,
formulas return values. they cannot perform actions such save as.
add this to your macro at an appropriate place.

Application.Dialogs(xlDialogSaveAs).Show

regards
FSt1

"Meredith" wrote:

> I wrote a macro in excel to facilitate creating monthly reports. I want it
> to save to a new folder each month (ie. the current monthly folder), but I am
> not sure how to write a changing "save as" formula.