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
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