I wrote a marco to copy and paste a wookbook in a folder for 31 days. I would then go into the folder and rename all the files like this 09/01/11, 09/02/11, 09/03/11 and so on. How do i get the marco to do this for me and then continue for the next month.
thanks
thanks