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.
pass today’s date in format of folder name while reading excel as file path.
if your folder name is 22_07_2020
What activity should i use for this?
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?
yes, no issues
Do you know how to convert a date format from 7/22/2020 to 20200721?
Mark as solution and like it
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.