Something along the lines of :

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

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

"Meredith" wrote in message
...
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.