+ Reply to Thread
Results 1 to 10 of 10

ingnore nonexisting subrouitine

Hybrid View

Guest ingnore nonexisting... 09-11-2005, 05:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 07:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 07:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 08:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 09:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 08:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 09:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 09:05 AM
Guest Re: ingnore nonexisting... 09-11-2005, 10:05 AM
Guest Re: ingnore nonexisting... 09-12-2005, 10:05 AM
  1. #1
    Norman Jones
    Guest

    Re: ingnore nonexisting subrouitine

    Hi Ron.

    > Take a look at the On Error statement and also the Beep statement.


    I do not think that a call to a non-existant procedure produces a trappable
    error.

    I think that the approach similar to that advocated by Ron de Bruin would be
    necessary.

    ---
    Regards,
    Norman


    "Ron Rosenfeld" <ronrosenfeld@nospam.org> wrote in message
    news:7338i1denvtumiej4ioctebskgmtqerebg@4ax.com...
    > On Sun, 11 Sep 2005 10:51:55 +0200, "Jack Sons" <j.sons@planet.nl> wrote:
    >
    >>Hi all,
    >>
    >>In the code below ABCD can be executed if it is a subroutine - sub
    >>ABCD() -
    >>in a module elsewhere in the same project. If ABCD is a not an existing
    >>sub
    >>the execution will halt, an error message wil appear on screen and a sound
    >>wil be produced. Fore some reason I want to hear that sound but I don't
    >>want
    >>the the program to halt. If possible it would be nice if also the message
    >>box does not appear, but I need to hear the error sound. To my regret I
    >>did
    >>not succeed with the code below.
    >>
    >>Anybody who knows what code is needed to let the program continue when
    >>execution comes to the line with the undefined ABCD but do let the error
    >>message sound hear?
    >>
    >>Jack Sons
    >>The Netherlands
    >>
    >>
    >>Sub ingnoreABCD()
    >>........... ' here the program already did some things
    >>Application.DisplayAlerts = False
    >>ABCD
    >>Application.DisplayAlerts = True
    >>.............. ' here I want to do what the program should do
    >>End Sub
    >>

    >
    > Take a look at the On Error statement and also the Beep statement.
    >
    >
    > --ron




  2. #2
    Ron Rosenfeld
    Guest

    Re: ingnore nonexisting subrouitine

    On Sun, 11 Sep 2005 12:07:48 +0100, "Norman Jones"
    <normanjones@whereforartthou.com> wrote:

    >Hi Ron.
    >
    >> Take a look at the On Error statement and also the Beep statement.

    >
    >I do not think that a call to a non-existant procedure produces a trappable
    >error.
    >
    >I think that the approach similar to that advocated by Ron de Bruin would be
    >necessary.
    >
    >---
    >Regards,
    >Norman


    I didn't realize that. Thank you for pointing it out.
    --ron

+ 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