Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access to send commands to IE9

Status
Not open for further replies.

Gandalph067

Programmer
Nov 28, 2012
9
US
Greetings,

I attempting to start a web based paging system internal to my company. I set the IE application, it will start the program but when it gets to IE.Visible = True I get an error "Run-Time error '-2147417848(80010108)': Automation error the object invoked has disconnected from its clients."

the program itself runs, shell opens two separate windows holding the program, both IE windows. But it will not go any further, just the error. I am trying to control the program from access and send paging info the form submit and close.

Any thoughts would be appreciated, thank you in advance

Function FillInternetForm()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
'create new instance of IE. use reference to return current open IE if
'you want to use open IE window. Easiest way I know of is via title bar.
IE.Navigate "'go to web page listed inside quotes
IE.Visible = True
While IE.Busy
DoEvents 'wait until IE is done loading page.
Wend
IE.Document.All("q").Value = "what you want to put in text box"

IE.Document.All("gbqf").Submit


End Function
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top