Norton 2008 causes VBA runtime error 430

[rvBasic]

I have an MS Access application that ran perfectly. Through a VBA macro module within that aplication, I accessed the Web to get some specific information that was subsequently added to the data base. That application ran without a problem when Norton 2007 was present.

After upgrading to Norton 2008 the application is broken. It now crashes with a Runtime error 430: Class does not support automation or does not support expected interface.

The code was absolutly the same.

I could pinpoint the error the to line where the IE was instantiated:

set objIE = new SHDocView.InternetExplorer

Do I have to adjust something in Norton?
and also How can I disable Norton 2008 (stop it from running)?




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

 

[rvBasic]

The latter question How can I disable Norton seems to be answered in a previous thread How can I temporarily disable Norton at

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

The recommandation was to run Services.msc from the start menu and to stop any service that starts with Symantec or Norton. When I run the command I have 4 such services: Symantec Core LC, Event Manager, Lic Netconnect service and Settings manager.

How can I be sure that there are no more somewhere hidden in my system? And if I stop them has Symantec then disappeared from my running system?

There sure (?) must be a simpler way to disable Norton?

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

 

[rvBasic]

Some additional information to describe the problem. I access the Webpages with the following VBA function:

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[/color]

'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

That piece of code is called repeatedly in order to access different WebPages. It has always run satisfactory, even with Norton 2007. After installing Norton 2008 it runs for some 3 to 5 calls and then it stalls at the blue instruction and the application ends with the said error code.

When subsequently I shut down 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]

 

[MichaelYork]

Hi rv,

This is Mike from the Norton Authorized Support team responding to your posting.

If you are having problems with a specific application, you will need to change the settings in the Personal Firewall to allow the application to work. Please follow the steps below to change your settings.

1. Open Norton Internet Security 2008 by going to Start->All Programs->Norton Internet Security, and then choose Norton Internet Security from the sub-menu.

2. In the main Norton Internet Security window, click on the "Norton Internet Security" tab at the top of the window.

3. Click on the arrow next to "Settings" to expand it's options.

4. Click on "Norton Internet Security Options."

5. When the window appears, click on the "Personal Firewall" link on the left.

6. Click on the "Personal Firewall" link on the left, and then click on "Program Control."

7. Click the "Add" button and then navigate to the location of the application you wish to allow and then click "Open."

8. Under the "Access" menu, choose "Allow." Click "Apply," and then click "OK."

Close the Norton Internet Security window and try to access your application again.

Please let me know if this resolves your issue.

Thanks,
Mike


Michael York
Norton Authorized Support Team
Symantec Corporation

http://service.symantec.com/priority

 

[rvBasic]

Michael, thanks for replying.

NO, authorizing the application (EXCELor ACCESS) does not help

I also disabled phishing (until next startup) but the problem persists.

I've prepared a small excel workbook that reproduces the problem consistently (i.e. works with Norton 2007 - does not with 2008). Can I send that somewhere?


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