I have a workbook that needs to be archived at the end of every month. I figured trying to create new sheets etc would be more hassle than its worth, so I just created a macro that I assigned to a button that will save the file at the end of the month - I have that part figured out.

Right now I have the macro saving the current workbook on as "File_LastMonth" - it's all pre-programmed. Is there a way to do it where excel will put it in the actual past month ? IE "File_June2013" ?

Thanks.