ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shell for Outlook (https://www.excelbanter.com/excel-programming/365950-shell-outlook.html)

WhytheQ

Shell for Outlook
 
is it possible to use something similar to the below to open a .msg
file from within an Excel macro (I've used the below previously to open
pdfs)

Public Function OpenOLfile(PDFFile As String) As Double
Shell "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " &
PDFFile, _
vbNormalFocus
End Function

Any help greatly appreciated,
Jason.



All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com