Macro to Create a set of folders and copy the active workbook

Hello, I am at a loss as to how to create this macro. I need the user to be able to click a button and it will create the folder "C:\Documents and Settings\LOCALUSER\My Documents\Checkouts\2009" with a subfolder for Jan through Dec. In these subfolders, I need to copy the attached workbook four times with the file names "Week 1" through "Week 4" except in March, June, September, and December I need files with names "Week 1" through "Week 5".

I can record and edit simple macro's but this is way over my head so I appreciate any help I can get.

Thanks!
Clayton Grove

Checkout Template

That worked. If I wanted to change where the folders were created, what would I change? I am pretty sure that is the correct path on my work computer but not positive so I would like to be able to change it when i get there.

Thanks!
Clayton

If you wanted to get your documents folder then you can test the path and others by:

Please Login or Register  to view this content.

What if I do not want to save it in the default file path. What if I wanted it to be just on "C:\checkouts\2009"?

Thanks!
Clayton Grove