Get the path of a current opened excel file

[CristianR]

Hi guys,

I have an application that opens an Excel file. I need to then get the path of this Excel file into a variable so I can input it further into the Excel Application Scope. Could you please help?

[umesh_desh (Umesh)]

Hi,

What activity are you using to open the file?

Regards,

Umesh

[CristianR]

Hi,

I am opening the file using a “Double Click” action in a application.

Best regards,
Cristi

[ddpadil (Dilip)]

Hi,
Please search before posting.

How to read Excel file dynamically?

Hi, You have to iterate through the files inside the folder and inside foreach use Excel application scope activity pass that item in the “workbookpath” which dynamically choose the file one after another . If you want to itereat through only today’s file follow my previous post else u can set the counter=1 in the foreah and exit after that. [image]