Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: adepreter on May 31, 2016, 10:55:47 pm

Title: Intellisense for Excel objects in VBscript
Post by: adepreter on May 31, 2016, 10:55:47 pm

Does anybody know how to add intellisense for Excel objects in VBscript?
Any type library that needs to be integrated?
Cheers,
Alain

Title: Re: Intellisense for Excel objects in VBscript
Post by: Geert Bellekens on June 01, 2016, 02:55:04 am

You can try writing the code in Excel's VBA environment and then paste it in your EA script.

If you are a bit careful most of the code will work right away.
AFAIK there's no way to extend the intellisense features of the VBScript editor in EA.

Geert