[Excel] List all Open Workbooks in Excel

[LaurentDelobell]

Hello,

I have to automatize a excel process which executes an excel macro that opens several existing excel files.
I tried to code an action able to list all Excel Workbook opened but I have some errors.

Here the code :


Is  there someone able to help me to find why this code is not working ?

Thanks a lot.

Laurent

------------------------------
Laurent Delobelle
------------------------------

[EVIPUTI]

Hi @Laurent Delobelle Can you share the error which you are getting while running this code . Also if there is a macro have you tried running it directly using "Run macro" action ?​

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------

[LaurentDelobell]

Hi Vipul,

Thank you for your help.
I ran the macro which opened excel files that I have to save or close manually depending of the filename. To do it I need to get the different workbook name.
Please find below the message :

------------------------------
Laurent Delobelle
------------------------------