To fetch modified date of an excel file.

[DGUPTA9]

Hi,

I want to fetch the modified date of an excel file using automation anywhere.Please help me regarding the same.

P.S. :- I have checked an activity of getting file date under if condition but in that activity we can not pass the variable for selecting a date.

 

[VJR]

Hi DGUPTA9,

I just checked and you're right there doesn't seem to be a direct way to get the modified date of a file.
As of now the only quickest option I can think of is to add a few lines of code in a vbs or js file that returns the modified date in a variable. Then run that script from AA and use the returned variable further in AA. Let me know if you want me to assist you on this.

If I find out anything directly in AA then I will let you know or if you come across anything then you can post here.

 

[BariGaurav15]

yes we can write excel macro and pass the folder path to macro it will give all the details regarding the file.