How can I obtain the actual version of Internet Explorer? 2

[GVF]

Using "...weboptions.targetbrowser" seems to return the setting that Excel uses when saving-as-a-webpage. I need to determine the actual version of IE that is installed on the machine. Later versions of IE will block ActiveX controls. I can unblock the control (MSCOMM32.OCX) from within VBA but if the IE version is 5 or earlier the "compatibility flag" registry key doesn't exist and an error is generated bringing up a dire warning dialog. So what I want to do is:
If IE_Version > 5 then Call EnableMSComm

 

[strongm]

here's one way that avoids API calls:

Dim ieVersion As String
ieVersion = CreateObject("wscript.shell").RegRead("HKLM\SOFTWARE\Microsoft\Internet Explorer\Version")

 

[GVF]

That'll work. Thank you very much.

Greg

 

[mscallisto]

Didn't know that; .RegRead could come in handy

(worth a star)

sam