On error resume next problem
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 |
On error resume next problem
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. 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 -- Dave Peterson |
On error resume next problem
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 |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com