Find Desktop Folder Files

[sooty8]

Hi All

I have lots of Excel invoice files in a desktop folder the path to the folder is
C:\Documents and Settings\Sooty8\Desktop\Invoices 2009
I have created a small UserForm with a textbox and a commandbutton
entering the invoice file number in the textbox say C204 then clicking the commandbutton how would I code it to find the file for me in the folder and highlight it so that I could then attach it to an Email and send it off to the client.

Many Thanks for any help.

Sooty8

[sooty8]

Hi

The files all are named - Invoice then the number -- Invoice 204

Sorry about missing that

Thanks

Sooty8

[mdmackillop]

Can you post a workbook containing your Userform.