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
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