Macro to correct filename syntax

[brumby]

hiya all,

I have each week 6 files which I link various source data to to allow me to keep an eye on things. below is an example of week 36 and the files that are live

Airbag_Material_Plan_36.xlsm
Airbag_Material_Plan_36_AB.xlsm
Airbag_Material_Plan_36_DP.xlsm
Airbag_Material_Plan_36_MG.xlsm
Airbag_Material_Plan_36_RD.xlsm
Airbag_Material_Plan_36_TR.xlsm

However during week 36, a recovered file came into play, so the files looked like this :

Airbag_Material_Plan_36.xlsm
Airbag_Material_Plan_36_AB (version 1).xlsb.xlsm
Airbag_Material_Plan_36_AB.xlsm
Airbag_Material_Plan_36_DP.xlsm
Airbag_Material_Plan_36_MG.xlsm
Airbag_Material_Plan_36_RD.xlsm
Airbag_Material_Plan_36_TR.xlsm

If possible I would like to either run a macro or batch file to look at the files and if a recovered / autosaved version comes into play, rename and delete the previous "old" saved file so in this example :-

Airbag_Material_Plan_36.xlsm
Airbag_Material_Plan_36_AB (version 1).xlsb.xlsm - becomes "Airbag_Material_Plan_36_AB.xlsm"
Airbag_Material_Plan_36_AB.xlsm - is deleted
Airbag_Material_Plan_36_DP.xlsm
Airbag_Material_Plan_36_MG.xlsm
Airbag_Material_Plan_36_RD.xlsm
Airbag_Material_Plan_36_TR.xlsm


Is this possible?

 

[mole999]

are there criteria that say (version 1) is the newsiest record, maaybe a date could be used so you get the newest ?

 

[brumby]

I could include date timestamp in save name. However it's onpy really to help catch the save problems i frequently get