Say I have a Macro-enabled Workbook containing 10 Macros that I wish to run in sequence, Is there an activity/LINQ/Process that will return a list of Macros(names) and store it to an IEnumerable or any other collection(List/Array) that I can loop through?
Or will I have to create a custom package to incorporate that as an activity into my studio?
Note, I wish to know if there is any way I can capture the existing macro names present in a given .mlsx file.
Clarity on this would be much appreciated, thanks in advance.
-Ashwin A.K(Speridian Technologies)