View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default 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.