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