Need Help: VBA Macro and IE8

A VBA macro is written as part of Outlook 2007.  The following technologies are used:

-          MS Word document creation from a template and uses bookmarks for content updates

-          IE automation to extract data from Process Center

-          Connects to Oracle DB to run a couple stored procedures

When migrated to Outlook 2010 it all seems to be ok there.  I have moved to Windows 7 and that brought along IE 8, and that is where I think I have a problem.  The code snippet below is where the problem occurs:

                Dim objBrowser As SHDocVw.InternetExplorer

                Set objBrowser = CreateObject("InternetExplorer.Application")

                objBrowser.Navigate "http://processcenter.web.att.com/viewrequest.aspx?id=114&requestid=" & IWR)

è           If InStr(objBrowser.LocationURL, IWR) = 0 Then

About any reference after the Navigate method causes the same error.  This worked fine under IE 7.

Any help on this will be great!!

Tweet