Rally : Excel add-in - Can we use the add-in functions in an Excel Macro?
Article ID: 106121
Updated On:
Products
CA Agile Central On Premise (Rally)
CA Agile Central SaaS (Rally)
Issue/Introduction
We would like to embed the Excel add-in queries in an Excel Macro. Can this be done?
Environment
Release:
Component: ACSAAS
Component: ACSAAS
Resolution
Unfortunately not. This can not be done.
The Excel Add-in is a COM Add-in. It does not expose its classes and methods publicly. Therefore it can not be included as part of the VBA references libraries in Excel and hence can not be instantiated by code. Specifically it can not be included in VBA scripts, functions including Excel Macro (which are VBA scripts).
The Excel Add-in is a COM Add-in. It does not expose its classes and methods publicly. Therefore it can not be included as part of the VBA references libraries in Excel and hence can not be instantiated by code. Specifically it can not be included in VBA scripts, functions including Excel Macro (which are VBA scripts).
Feedback
Yes
No
Powered by
