SAP IRPA/Build Get Open Workbook List gives more records

[liskaj01]

Hi experts, do you have any idea why this function doubles entry for each open workbook?

For example if I have one workbook open, it gives two records to the list - one is with complete path, eg. C:\IRPA\workbook1.xlsx and the other one is workbook1.xlsx

In such case its not possible to add loop that gets the path and closes the workbooks that I want. Actually its possible using also Try Catch in the loop, but still would like to have only one results for each opened workbook. Isnt that a bug that it gives more inputs for one workbook? Thank you

SAP Build Process Automation @Chaitanya_Priya 

[Sankara1]

Hello Liska,

Thank you for reaching out to us. As a best practice, we recommend starting by closing all open Excel instances and initiating the loop afresh. If a workbook is already open, there is a possibility that Excel may update it incorrectly. Additionally, please ensure that the workbook path is properly maintained.

Let us know if you need further assistance.