On error resume next problem

F

freekrill

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 ge
an error message. Shouldn't the instruction, On error Resume Next
prevent this problem?

Thanks for any explanation

Cheers
fre
 
D

Dave Peterson

Next time you're in the VBE, try:

Tools|Options|General tab
check "Break on Unhandled Errors"

I'm betting that you have "break on all errors" checked.
 
E

exceluserforeman

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>>>
 
Top