Macro to pick up the last autorecovered file and rename it with the original file name

[Jirka79]

Hi all,

Unfortunately, in my work, we are experiencing quite often some excel crushes (electricity cuts, etc...) and then, the operators restart the pc and reopen the Excel file where they introduce the production data and they are struggling everytime that it happens because they don't know which recovered file they need to pick up.... and besides, when they pick up one of the recovered files, they keep working with the production file but under the name of the recovery file (for example file name "XXXX (version 2).xlsb (autosaved)" and then I'm the one struggling because then other macros I have they don't work properly when the file name is not the original one, with the extension .xlsm.

So, my idea was to create a button for the operators with a macro that automatically takes the last recovered file and renames the file to the normal file name (the original file name with .xlsm).

I've been surfing the net but I don't find such a thing... So, please, is there a code that could do what I'm looking for?

Thank you all in advance for your kind attention!

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Macro to pick up the last autorecovered file and rename it with the original file name
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.