View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ozzie via OfficeKB.com Ozzie via OfficeKB.com is offline
external usenet poster
 
Posts: 41
Default Deleting Duplicate workbooks

Dear Experts

Is there a way of being able to check a network folder for file names
containing the same piece of text?

I have a spreadsheet which people now automatically save to a specified
folder "W:\Accounts\Site Daily Bankings\To be posted".

However some people are saving their file more than once (a user problem that
unfortunately won't go away) which I need to filter and delete. The file's
are saved with the site name, then a date stamp, i.e. "SiteName Banking
09Mar2006_152600"

Ideally I would like to search on the first piece of text as it is always the
site, but how would I delete the others ?;

Ie, if I have

SiteName Banking 09Mar2006_152600
SiteName Banking 09Mar2006_152599
SiteName Banking 09Mar2006_152598

I would want to keep "........152600" and delete the other two.

Anybody any idea's?,

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