IDE Detection

How do you programmatically determine if the IDE is running?

Thanks in advance.

CodeHacker
Rate me if it helped, Thanks

Debug.print 1/0




If the Ide is running, the above statement will produce an divide by zero error. If IDE is not running the statement is ignored.

John G

Thanks. Why didn't I think of that. Then I can just route any code I need on an on error block. Duh. 8-)

CodeHacker
Rate me if it helped, Thanks

Have also a look here:
http://codeguru.com/cgi-bin/bbs/wt/s...age=&view=&sb=

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.