Hi Folks,

I'm hoping this can be accomplishedin a macro...

A user opens an excel file and fills out the necessary info for the prior
days usage. I can create the button which links to the macro that saves the
file as the previous days date and emails it as an attachment, but I would
like the file to know where to save itself according to the month of the save
as date.

I have a folder named "2006" and subfolders named "January", February",
etc... Is there a way through a macro to have the file save in the correct
months' folder?