Link to Excel File on Outlook Form

  • Thread starter Thread starter freeman642
  • Start date Start date
F

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