Author Topic: Intellisense for Excel objects in VBscript  (Read 4097 times)

adepreter

  • EA User
  • **
  • Posts: 187
  • Karma: +10/-9
    • View Profile
Intellisense for Excel objects in VBscript
« 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

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Intellisense for Excel objects in VBscript
« Reply #1 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