list the files to delete into a listbox.
Use the application.filesearch for found files from your listbox
if foundfiles (i) then
kill (i)
Then removeitem (i) from the listbox.
Zero must be a line label
Put a 0 somewhere
"freekrill" wrote:
I have some code which looks something like this
On error Resume Next
Kill "C:\a.xls"
Kill "C:\b.xls"
Kill "C:\c.xls"
Kill "C:\d.xls"
Kill "C:\e.xls"
On error goto 0
It works ok, but if the file doesn't exist the macro breaks and I get
an error message. Shouldn't the instruction, On error Resume Next,
prevent this problem?
Thanks for any explanation
Cheers
free
--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=490966