• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to Save File and then create a copy [SOLVED]

C

Cammandk

Member
I have a file called OTR2CMMaster.xls


At the end of the month I want to save off where we are and create a seperate accounts file to use for month end.


I want to run a macro that will save this master file and then create a copy and save as OTR2CMSageJun13 - the Jun 13 refering to the month.


The OTR2 is a Name "ProjectCode" in the workbook if that helps. I will end up with different files to save.
 
Hi, Cammandk!

Check this, just out of the oven:

http://chandoo.org/forums/topic/add-date-to-excel-file-name

Regards!
 
Hi

Looked at link but can't see how to amend code for what I need.

I want to once a month perform this function - save a copy of file to the project code name with the current mmm/yy then save the file withe the current Master name
 
You must log in or register to reply here.
Back
Top