CODEWITHSUNDEEP
excelvbaoffice-jsjavascript-api-for-office
SoftTimur
SoftTimur

Reputation: 5540

Get all the VBA macros of a workbook by JavaScript API for Excel

In VBA, we could use for example Wb.VBProject.VBComponents to fetch all the VBA macros of a workbook Wb.

Does anyone know if JavaScript API for Excel provides any object or function to access that?

Upvotes: 0

Views: 572

Answers (2)

Michael Zlatkovsky
Michael Zlatkovsky

Reputation: 8670

No, you cannot get the VBA macros out of the workbook using JS APIs.

Out of curiosity, why would you want to do it? I.e., what would be the pitch you'd make for having us include this API?

~ Michael Zlatkovsky, developer on Office Extensibility team, MSFT

Upvotes: 0

ThunderFrame
ThunderFrame

Reputation: 9461

I think this github project is what you're looking for:

https://github.com/vbaidiot/Ariawase/blob/master/vbac.wsf

Upvotes: 0

Related Questions