How to select the excel with part name variable?

Help StudioX
1

Hi all,
How to select the excel with part name variable?
the date of the excel name “invoice_20230409.xlsx” will change every time. Is there an expression like
“invoice_”&“*”&“.xlsx”？

2

Hi @jackie.yue

Try this.

Directory.GetFiles(FolderPath,“Invoice_*.xlsx”)

You will get array of all file paths of files with that keyword.

You can use this too:

image

Hope it helps.

2 Likes
3

Thanks Harshith. There is only one excel with part name variable. How to choose it?

4

Directory.GetFiles(FolderPath,“Invoice_*.xlsx”)(0)

Try this.

5

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