Solved How i select a current date file from folder using BP tool

[Puneet]

Let say there is a folder which have files like 'ABC_04032018' & 'ABC_05032018' and i have to pick a current date file from folder which is 'ABC_05032018'. how i achieve this.

 

[VJR]

Hello Puneet,

You can try using the 'File Exists' action of the 'Utility - File Management' VBO.
Before that you will need to format the name of the file as per today's date.
"ABC_"
Concatenate the above text with formatting to today's date in DDMMYYYY format so that the resultant file name string will be ABC_04032018
If the file exists then you can proceed further on what you need to do with that file.

 

[Puneet]

ok. Thanks VJR for your time.

Scenario is
My Bot execute and he collect some data from web and then save it into the folder with current date. I have to send that current date file using an email.

 

[VJR]

For the email part, anisjolly has responded to you here
http://www.rpaforum.net/threads/how-to-read-excel-file-dynamically.638/#post-1324