PDA

View Full Version : Find Desktop Folder Files



sooty8
01-22-2010, 09:31 AM
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
01-22-2010, 09:45 AM
Hi

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

Sorry about missing that

Thanks

Sooty8

mdmackillop
01-23-2010, 09:34 AM
Can you post a workbook containing your Userform.