Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

outlook style attachment shortcut in XL

Status
Not open for further replies.

Gallowgate

Technical User
Mar 4, 2003
14
GB
I am writing a programme to aid quality assurance in our office. It serves as a database for all communications, incoming & outgoing and generates unique references for documents.
At the moment I use getopenfile to allow the users to pick the file they refer to, e.g their letter, or their email attachment and the path is then passed to a label on the userform and then written to the 'database' as text.

Is there any way that I can emulate the small icon that appears in outlook when one selects an attachment, but it just act as a shortcut to the file ?

I ask as if the user picks say 10 files that were attached to his or her email the text could get a little unwieldy
Excuse me if this is a stupid question but I've only been at this vb lark for about 4 days !

Thanks

Martin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top