Tom,

I have sorted this, basically I have taken the hhmmss time stamp off and
turned off the warning so now every time the spreadsheet is saved it
overwrites the previous version so I only have one per site,

Thanks for your replies

Tom Ogilvy wrote:
so the little old ladies can't look at a sorted list of file names and delete
the rows that contain file names that contain the most recent date (where
there are duplicates) or delete the row (where the file name is not
duplicated), but they can look at individual filenames one at a time in a
prompt and determine whether to delete them or not.

anyway, you showed
SiteName Banking 09Mar2006_152600
SiteName Banking 09Mar2006_152599
SiteName Banking 09Mar2006_152598

where all the dates are the same date. What is the number on the end?

then in the latest you spoke of

i.e. First name and last name

Do you actually want the macro to make the decision to delete.

Would need to know specifics about the filenames and how to distinguish what
part of the name would be duplicated and what would indicate which is the one
to retain.

Tom,

[quoted text clipped - 77 lines]

Anybody any idea's?,

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1