Retrieve the file name if I specify the extension.

[veerusat]

Hi everyone can you help me withthis.................plz..............

I have a xml file in which there are lot of file names arepresent.
For Example:
<abc>qwerty.pdf</abc>

So I have to create a vba code such that if I search with".pdf" then it has to give me the answer as"qwerty"..............

Plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz help me

[Bob Phillips]

Lookup the Dir function in VBA help.

[veerusat]

Hi xld.............

Thanks alot for replying...........

But boss I am new to VBA ..I read throught that but couldn come to a conclusion........

So can you help me......plz............in detail.....with the code............