How to read only first excel from folder

Help
1

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:

image
image1366×768 64.7 KB

please help :frowning:

2

Get the time stamp of the each file and pick up the file.

3

i am getting this error

image
image1366×768 52.6 KB
, do u have sample code

1 Like
4
5

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

1 Like
6

if im keeping out_folderpath is string varible then getting following error:

image
image1366×768 72.5 KB

1 Like
7

Fine
Kindly try with this @smita.mobifly
out_folderpath = Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0)

1 Like
8

its working but it open excel into system.

9

i didnt get this buddy
@smita.mobifly

10

while i run this code open excel on system

image
image1366×768 82.2 KB

11

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

1 Like
12

you are correct, thank you so much…:slight_smile:

13

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