|
-
Mar 24th, 2011, 01:18 PM
#1
Thread Starter
New Member
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|