Activating VBA code designers

[gxdata]

This question was put to me, and I think the idea was to get the
intellisense and design hints of the programming IDEs and use the generated
code within another application that uses VBScript (and VB.NET scripting),
but has a rudimentary design interface.

The question is: if Office (let's say Office 2002 - maybe just Excel 2002)
is installed on a machine, how can I programmatically launch the (Excel)
Tools > Macro > Visual Basic Editor, and work in it? (the keystroke from
Excel is Alt+F11, so I'm guessing that an Excel object could be created, and
the keystroke passed).
Similarly, the Microsoft Script Editor (keystroke Alt+Shift+F11).

Comments?

 

[Jim Vierra]

I don't think there is anyway to do what you want. I would download the
Microsoft Script debugger and use that to build scripts. It's not quite as
good as the VBA editor but it's close.

Here's one editor that is pretty good with Intellisense
http://www.vbsedit.com/ There are many/many more out there.

Launch MSAccess and put a breakpoint in the startup code. It should come
up with the Editor/Debugger window
displayed. To break use an Assert statement that resolves to false.