View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Getting Outlook version number

On Sun, 24 Mar 2013 09:51:12 +0100, "Charlotte E." wrote:

Hi all,


I'm running Excel 2003 and Outlook 2010.

Is it possible to obtain the version of Outlook from Excel VBA?


TIA,

CE


With Excel 2007, the following works:

==============================
Option Explicit
Sub GetOutlookVersion()
Dim objOL As Object
Set objOL = CreateObject("Outlook.Application")
Debug.Print objOL.Version
End Sub
=========================