ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Outlook version number (https://www.excelbanter.com/excel-programming/448467-getting-outlook-version-number.html)

Charlotte E.[_3_]

Getting Outlook version number
 
Hi all,


I'm running Excel 2003 and Outlook 2010.

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


TIA,

CE

Ron Rosenfeld[_2_]

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
=========================

Charlotte E.[_3_]

Getting Outlook version number
 
It also works in XL2003 :-)

Thanks...


CE


Den 24.03.2013 13:03, Ron Rosenfeld skrev:
Option Explicit
Sub GetOutlookVersion()
Dim objOL As Object
Set objOL = CreateObject("Outlook.Application")
Debug.Print objOL.Version
End Sub
=========================



All times are GMT +1. The time now is 04:06 PM.

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