Solved

How to tell if in IDE

Posted on 2003-02-26

Visual Basic Classic

1 solution

Medium Priority

144 Views

Last Modified: 2010-05-01

Is there an easy way, via code, to tell if you are in the IDE as compared to a compiled app?

I want certain code to not run in the IDE but too run in the exe.

Comment

Question by:KOCUBA

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 28

Accepted Solution

by:vinnyd79

vinnyd79 earned 150 total points

ID: 80268042003-02-26

http://www.freevbcode.com/ShowCode.Asp?ID=145

LVL 2

Expert Comment

by:IrishPheremone

ID: 80281952003-02-26

Public Function DEBUG_MODE() As Boolean
On Local Error GoTo HandleError

' Error (only in ide mode) {
Debug.Print 1 / 0
DEBUG_MODE = False
'}

Exit Function
HandleError:

' Ide {
DEBUG_MODE = True
'}

End Function

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Class Item Filtering Via Dynamic Scripting

Article by: aikimark

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library. This article will introduce you to the SC library a…

Visual Basic Classic

Using the VB6 Debugger

Article by: Martin

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture. There is also a companion Debug Toolbar that looks like the followin…

Visual Basic Classic

Executing a Windows API Function from Access

Video by: TechMommy

As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…

Basic Error Handling code for VBA and Microsoft Office

Video by: crystal

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…