topic RE: Open WorkBook With Changing File Name in Product Forum

Open WorkBook With Changing File Name

AsitabhaDeb — Wed, 28 Oct 2020 14:53:00 GMT

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

RE: Open WorkBook With Changing File Name

shashank.kumar280 — Wed, 28 Oct 2020 15:53:00 GMT

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

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

RE: Open WorkBook With Changing File Name

AsitabhaDeb — Thu, 29 Oct 2020 01:21:00 GMT

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

RE: Open WorkBook With Changing File Name

shashank.kumar280 — Thu, 29 Oct 2020 04:44:00 GMT

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