Excel!

Can anyone assist me with get a bot to open a excel file in a folder based on today’s date? I need the bot to navigate to a folder and be able to open the file with today’s date in the file name.

1 Like

Hi @bagayoko.isaac.b,

pass today’s date in format of folder name while reading excel as file path.
if your folder name is 22_07_2020
then pass:

now.tolocaltime.tostring(“dd_MM_yyyy”)+"\Filename.pdf"

Thank You
Shubham Pratap
@Shubh1801

What activity should i use for this?

1 Like

Hi @bagayoko.isaac.b,

Read Range , used to read excel file

I am trying to open the file from a folder though, so should read range be my first action?

1 Like

yes, no issues

Do you know how to convert a date format from 7/22/2020 to 20200721?

Hi @bagayoko.isaac.b

dateVariable.ToString(“yyyyMMdd”)

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.