What code will determine at run time if execution is from within the IDE?
Bill

Try this code:

Private Sub Form_Load()
    On Error GoTo IDETest
    Debug.Print 1 / 0
    MsgBox "Running as an EXE"
    Exit Sub
IDETest:
    MsgBox "Running in the IDE"
End Sub

The Debug.Print statement causes an error only in the IDE because all Debug
statements are dropped out of the compiled EXE, like comments.

Lee Weiner
weiner AT fuse DOT net
http://home.fuse.net/lweiner

Hi Bill,

There are many ways to find this, but the most clever one i have seen
utilizes the fact that the Debug.Print statements are dropped from the code
at compile time.
Here is a function that will return True if your program is running in the
IDE:

Function InIDE() As Boolean
    InIDE = False
    On Error Resume Next
    Debug.Print 1 \ 0

    If Err Then
        Err.Clear
        InIDE = True
    End If
End Function

Regards,
                 Stoil

The API GetModuleHandle() will return the Windows handle to a currently
running module.  If the module is not running, it returns zero.  The
following line:
    bolIDE = GetModuleHandle("vb6.exe")

sets a flag, bolIDE, that can be used within the program to determine if VB
is running.  The drawback is that if the user is running your program, and
is ALSO running VB for whatever reason, this method will not work (it just
tells if VB is running; it doesn't make tell if your app is being run from
it).