vba to save as created date or based on cell data

[rooster05]

hi,

i have 3 xl files named current, previous and macro. current is a report that is run every other day and uses vlookups to the previous file (previous is the current file in a completed state). macro is an empty file except for a macro to run all vlookups on the current file.

when all the vlookups are complete i need to rename current & previous to -
previous to the creation date
current to previous

is there a way i can run macro to rename these

hope this is clear


thanks in advance

 

[Momentman]

Are you renaming or doing a save as

If you are renaming, maybe something like this. It assumes your file is in the path "C:\myname", change to reflect location of your actual file

it renames the PREVIOUS to just the "Current date", I am unsure what you mean by "Creation date"

UNTESTED - you should be running the codes from outside both files

Sub Newtest()
    Name "C:\myname\previous.xlsx" As "C:\myname\" & Format(Date, "dd_mmm_yyyy") & ".xlsx"
    Name "C:\myname\Current.xlsx" As "C:\myname\previous.xlsx"
End Sub

If you are doing a saveas, it should be relatively easier

 

[rooster05]

Sorry didn't explain that, by creation date i meant the file /report was run i wondered if this info could be obtained somewhere within the file itself.
and i trying to save as