Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |