Excel 2007 : Runtime error running macro to open IE and search for string

Hello Aaecae, welcome to the forum.

Please take a moment to read the forum rules and in the future:
1. Wrap your code in CODE tags. (Rule 3)
2. Use a thread title that is more descriptive of your issue (Rule 1)

Regarding your problem:
1. In the VB Editor click Tools -> References, scroll down and select 'Microsoft Internet Controls' then click OK
2. Update your code as shown below:

Sub AutomateIE()
Dim ie As InternetExplorer
Dim RegEx As Object, RegMatch As Object
Dim MyStr As String

Set ie = New InternetExplorer
Set RegEx = CreateObject("VBScript.RegExp")

'Search google for "vbax kb"
ie.Navigate "http://www.google.com.au/search?hl=en&q=vbax+kb&meta="

'Loop unitl ie page is fully loaded
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop

'String to parse google search for a VBAX reference
With RegEx
.Pattern = "www.vbaexpress.+?html"
.MultiLine = True
End With

'return text from google page
MyStr = ie.Document.body.innertext
Set RegMatch = RegEx.Execute(MyStr)

'If a match to our RegExp searchstring is found then launch this page
If RegMatch.Count > 0 Then
ie.Navigate RegMatch(0)
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop
MsgBox "Loaded VBAX link"
'show internet explorer
ie.Visible = True
Else
MsgBox "No VBAX link found"
End If

Set RegEx = Nothing
Set ie = Nothing
End Sub