+ Reply to Thread
Results 1 to 3 of 3

On error resume next problem

  1. #1
    Registered User
    Join Date
    03-25-2004
    Posts
    57

    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

  2. #2
    Dave Peterson
    Guest

    Re: 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. #3
    exceluserforeman
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1