I have used code to save the worksheet to add the date and time on save function. I am now trying to delete the previous versions automatically when either saving or exiting the latest worksheet. Can you assist please?
Many Thanks
Robbosan
I have used code to save the worksheet to add the date and time on save function. I am now trying to delete the previous versions automatically when either saving or exiting the latest worksheet. Can you assist please?
Many Thanks
Robbosan
Not sure I understand. Are you talking about worksheets or workbooks? Are you making a copy of the worksheet within the workbook, or making a copy of the workbook using SaveAs?
Either way, automatically deleting previous versions is a risky strategy. If you screw up processing the current version, and you automatically delete previous versions, then you have nothing to fall back on.
No worse than working all day then closing Excel, maybe while looking at another workbook and not saving changes ... but, at least, this is in your control.
My advice: don't.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks