Get path

Guys i would like to open and do operations on only excelsheets that are present in a specific folder.
But for that i need to know their paths.Is there any logic through which i would be specifically able to retrieve excels from that folder and do a set of operations on it.

Check this:


GetFiles(“YourPath”,".xls") should help you.

2 Likes

How you open the file without knowing path?
Only way if you know the name of the file you can search in run but qn is how you know the file name
whats the source files are coming?

my files are being stored from the email(attachments) i obtain.
these files are saved to a specific folder.@ddpadil
@akhi_s27
thank u