Open Excel in a folder based on saved attachment

[bebxadvlmeu (Laurence De Meulemeester)]

Hi everyone

Can anyone help me with the following problem: I saved an attachment (excel) from a mail in a folder. Now I want to open the file and read values from the Excel. This means that each time the name of the document can be different depening on the attachment saved so if I want to add the Excel application scope I can not add the name of the document?

Can anyone help me with this? THanks!

[ddpadil (Dilip)]

Hi,
You just has to pass item from the foreach loop to the excel path.
Please refer the following.

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]