topic [Excel] List all Open Workbooks in Excel in Product Forum

[Excel] List all Open Workbooks in Excel

LaurentAxa — Mon, 06 Sep 2021 16:35:00 GMT

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
------------------------------

RE: [Excel] List all Open Workbooks in Excel

EVIPUTI — Tue, 07 Sep 2021 04:59:00 GMT

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
------------------------------
------------------------------

RE: [Excel] List all Open Workbooks in Excel

LaurentAxa — Tue, 07 Sep 2021 07:50:00 GMT

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
------------------------------