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