I have multiple file like as
Excel1
Excel2
Excel3
want to read latest one.
this is my following code but its not work getting error please help:
please help
I have multiple file like as
Excel1
Excel2
Excel3
want to read latest one.
this is my following code but its not work getting error please help:
please help
Get the time stamp of the each file and pick up the file.
hi
out_folderpath = Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)
where out_folderpath is a string variable
Cheers @smita.mobifly
Fine
Kindly try with this @smita.mobifly
out_folderpath = Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0)
its working but it open excel into system.
disable the VISIBLE property in the excel application scope activity so that it wont show in foreground of the screen
Kindly correct me if i have understood the query wrongly
@smita.mobifly
you are correct, thank you so much…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.