Find Today date named Excel_Read Range

111153 · October 13, 2021, 2:41am

Hello.

I saved Excel file using
"Excel_" + now.tostring(“yyyyMMdd”)

And after that, I want to read that file.

But as I know, I can’t use now.tostring(“yyyyMMdd”) for WorkbookPath in Read Range Activities.

How can I solve this problem?

lakshman · October 13, 2021, 2:45am

Create one string variable and assign that value.

     varFileName = "Excel_" + now.tostring(“yyyyMMdd”)

Then pass it to save excel file and also pass the same variable to workbook read range activity to read the file.

111153 · October 13, 2021, 2:51am

Umm Saving project and read range project are divided for some reasons…
Is that possible to select workpath with tostring for this activity??

lakshman · October 13, 2021, 3:48am

Here you pass the string variable which holds file path.

111153 · October 13, 2021, 4:25am

Like this??

lakshman · October 13, 2021, 4:54am

Try this.

        strExcel = "Excel_"+Now.ToString("yyyyMMdd")+".xlsx"

In Excel Application Scope activity, pass as below.

     "C:\Users\hwan-min.je\Downloads\"+strExcel

111153 · October 13, 2021, 8:37am

Thank you it works!