Link to Excel File on Outlook Form

[freeman642]

I need to have a link on an Outlook VBA form that links and opens an
excel file, does anyone know of a way to do this? Have seen links to
internet explorer but not opening a file on a shared network drive.

Thanks John

 

[Sue Mosher [MVP-Outlook]]

The file:// URL syntax should work with any file. Or, use Excel automation methods.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

 

[freeman642]

On excel automation methods can I reference all versions of excel
library excel.exe and the machine will find the right one or do I ahve
to get what version and then select the right reference.

Thanks John

 

[Sue Mosher [MVP-Outlook]]

Excel automation is not version specific. You can use CreateObject("Excel.Application").

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

 

[Eric Legault [MVP - Outlook]]

Sue, do you know of any intrinsic controls that can be hyperlinked? From
what I remember there are none so you need to use Shell commands.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

 

[Sue Mosher [MVP-Outlook]]

No, not VBA form controls, but the IE automation tecnique that the o.p. cited should also work for file:// URLs not just http:// URLs.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54