Norton 2008 causes VBA runtime error 430

[rvBasic]

This thread is (almost) a duplicate. The original was posted on the Symanec: Norton Antivirus forum at

http://www.tek-tips.com/viewthread.cfm?qid=1453169&page=1

As the problem relates to automating the IExplorer through VBA, I also post my severe problem on this forum

I have used the following function for years to extract information from WebPages. I have used it in Excel and Access 2003 and
2007 without a problem. The environment included Norton 2006 and later 2007. But after I upgraded - without any other change - to Norton 2008
it broke.

The function is called repeatedly to consult different webpages. After 3 to 5 calls, it stalls at the blue instruction and then it ends with
Runtime error 430: Class does not support automation or does not support expected interface.

Public Function WebPageBodyString(strUrl As String) As String

Dim strResult As String

'create a hidden instance of IE
Dim objIE As SHDocVw.InternetExplorer
[COLOR=blue]Set objIE = New SHDocVw.InternetExplorer[/blue]

'open webpage
On Error GoTo PROC_ERROR
objIE.Navigate strUrl

'wait for page to complete loading
Do Until objIE.ReadyState = READYSTATE_COMPLETE
    DoEvents
Loop

strResult = objIE.Document.body.innerHTML

PROC_EXIT:
    
    objIE.Quit
    Set objIE = Nothing
    WebPageBodyString = strResult
    Exit Function
    
PROC_ERROR:

    strResult = vbNullString
    GoTo PROC_EXIT

End Function

When subsequently I shutdown my system, I get an error message: DDE Server Window does not react.

My guess is that somewhere Norton 2008 must interact in another way with a automated (programmed) call to the InternetExplorer. Could it be some kind of memory leak?

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[xlbo]

I have seen Norton cause all kinds of errors in VBA

It is likely that the only way to fix it is to not use Norton

You are setting your objects to nothing after use so unlikely to be a VBA memory leak

Sorry I can;t be much more use - Norton can be a pain for stuff like this...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question