Open WorkBook With Changing File Name

[AsitabhaDeb]

Hi Experts,

In my process I download Excel file on daily basis ( Name: Excel 28.10.2020.xls) from SAP. Next day the new file will replace the previous days file ( With Name Excel 29.10.2020.xls). 

My requirement is BOT will pick up current date file in process level when I select action Open Workbook.
 How I would do that. Please guide me.

What will be my expression under Open Workbook.

BR/Deb

------------------------------
Asitabha Deb
------------------------------

[shashank.kumar280]

Try this "Excel "&FormatDateTime(Today(), "dd.MM.yyyy")&".xls"

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[AsitabhaDeb]

Thanks Shashank,

Its working fine now.

Can you please tell me there is a Sheet Name in a excel file which is changing on every day.
For eg - Backlog 10.29.20, next day its become Backlog 10.30.20 and so on.

How to capture that in BP for " Get Worksheet as Collection" Process.


------------------------------
Asitabha Deb
------------------------------

[shashank.kumar280]

Hi Asitabha,

You will have to generate the sheet name using calculation stage and pass that to "Get Worksheet as Collection" action. 

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------