Excel!

Help Studio
1

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
2

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

4

What activity should i use for this?

1 Like
5

Hi @bagayoko.isaac.b,

Read Range , used to read excel file

6

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

1 Like
7

yes, no issues

8

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

9

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:

10

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