Detecting whether app is compiled or running in IDE

[apkohn]

Is there any way to detect whether an application is running in debug mode in the IDE, or whether it is a compiled program?

 

[rvBasic]

The hard(?) way is through an API:

http://www.vb-world.net/tips/tip506.html

The akward VB way could be as follows:

Private Function IsExecutable() As Boolean
On Error GoTo PROC_ERROR
Debug.Print 1/0
IsExecutable = True

PROC_EXIT:
Exit Function

PROC_ERROR:
IsExecutable = False
GoTo PROC_EXIT

End Function

The function is based in the fact that the Debug method only executes within the IDE envinronment. When the program is compiled the calls to the Debug method are omitted, so the code falls through and the IsExecutable = True statement is executed.

Within the IDE, the Debug.Print 1/0 is executed and provokes an error. Control is then switched to the PROC_ERROR label, which subsequently sets the IsExecutable = False
_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[apkohn]

Thanks RV. I ended up using the API call,and it works great