Renaming of files or workbooks.

[GEMINI528]

Hello Excel gurus,

I need help to automate the process below:
I have 2 identical files, file “A” and file “B”. I use file “A” for the daily entry and file “B” for the end of the month consolidation of data (similar to purging). A third file was also created as an archive copy. I don’t mind doing the long process but sometimes I am on leave and the person doing it has limited knowledge on Excel. I don't want my files to mesh up., that’s why I come up with this idea.

Here’s the long process:
At the end of each month I ran the code from file “A” to consolidate and transfer the consolidated data to file “B”. Once data has been transferred, I rename file “A” with “A MMM YY” (ex. “A Oct 14”), (or save it as file “A MMM YY” and delete file “A”) then, while file “B” still open, I save it as file “A” to be used for the transaction for the following month. File “A” and file “B” is on drive C and archive file is on drive “F”. (F:\Archive\A Oct 14).

Than you in advance for your great help.

[natefarm]

I'm not sure what is to go into the archive file, but maybe you can take it from here.

Please Login or Register  to view this content.