Results 1 to 10 of 10

Thread: [RESOLVED] IE Object becomes "unknown" after Navigate called

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2011
    Location
    Yarmouth, ME
    Posts
    5

    Resolved [RESOLVED] IE Object becomes "unknown" after Navigate called

    Some code that used to work for me seems to have stopped working. I am using Windows Vista and Access 2007, and recently installed IE9, but am not positive that this was related to that installation... so I un-installed the IE9 update to return to IE8, but this problem continues.

    My code is as follows (edited to show only relevant lines):

    Dim WithEvents mobjIE As InternetExplorer
    Dim strURL as string
    Set mobjIE = New InternetExplorer
    mobjIE.Visible = False
    mobjIE.StatusBar = False
    mobjIE.Silent = True
    strURL = "http://download.finance.yahoo.com/d/quotes.csv?s=ABB,ABD,AFL&f=sl1d1t1dr1"
    mobjIE.Navigate strURL
    While mobjIE.ReadyState <> READYSTATE_COMPLETE: DoEvents: Wend

    Almost everything seems to work fine up until the last line... the only oddity is that the Explorer window IS visible. I see the correct information for the URL above come up in a new (and visible) IE window, and then my debugger break point on the last line kicks in. If I hover the mouse pointer over mobjIE.ReadyState as soon as the breakpoint is reached, I see:

    Automation errorThe interface is unknown

    and a while later (perhaps a minute or so) this changes to:

    The remote server machine does not exist or is unavailable

    Meanwhile, if I open a Watch window and enter mobjIE, it does not show any variables for this object.

    Yet, if I set the break point one line earlier, and examine mobjIE BEFORE the navigate method is called, I see all information about the object as I would expect to. It seems as though the Navigate method is closing the IE object... yet the window with the results of the call remains open on my screen.

    I have also:
    - taken my ACCDB file to a client's computer (Win 7, IE8, Acc2007), and successfully run the same code without problems... so the trouble does seem to be a corruption on my machine.
    - Run sfc, and other windows corruption-checker tools from Microsoft, but that did not solve anything.
    - re-installed IE9, which works fine as a standalone application, and un-installed Access 2007, rebooted, and re-installed Access 2007.
    - Copied all elements of my database into a new database file, with no change in the symptoms.

    Any suggestions on next steps to try to resolve this? Thank you!
    Last edited by GWFYarm; Mar 25th, 2011 at 07:01 PM. Reason: Information from additional testing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width