Hi,
I have code in my Access VBA to open a web-based address (internal to our organization). I have posted the first part of my code below. For starters, the browser displays even though I have visible set to false, and then the do loop creates this error:
"ErrorReadData -2147417848 - Automation error
The object invoked has disconnected from its clients."
The Access DB should read the data and update my forms. It runs as it should on some PC's but not others. The plan is to run it from a Windows Server 2012 R2 machine, but it won't run there as well. (When I say won't run, I mean the visible false doesn't work and I get the error listed above.)
CODE:
Set objIE = CreateObject("InternetExplorer.Application")
With objIE
'don't display the browser
.Visible = False
'open the browser
.navigate strNavigationPath
'read the data on the site
Do While .ReadyState <> 4
DoEvents
Loop
Thanks,
Darryl