How to filter specific excel file name?

[phoenix123 (Isaac Lee)]

Hi guys! For the following code, can I get the file name like Balestier 11-Apr for this code?

[lakshman (Ganta lakshman)]

@phoenix123

Assign your file path to one string variable and say ‘filename’.

Then try this:

Path.GetFileNameWithOutExtension(filename)

[phoenix123 (Isaac Lee)]

@lakshman hi sir, I am currently using Exl.CurrentWorkbook.FullName.ToStiring but gives me file path but how can I specify the file name like Balestier 11-Apr only/

[lakshman (Ganta lakshman)]

@phoenix123

You printed one value in message box right and same one Assign it to one String variable and try above method.

[phoenix123 (Isaac Lee)]

@lakshman yup around that do you have any solution or ?