Excel's VBA manipulating Internet Explorer Form
Posted on 2003-03-10
Greetings - this one should be quite simple, but I just can't figure out the syntax.
I am trying to write a VBA program in Excel which launches Internet Explorer, Navigates to a specific web page, and pastes information into the Form on that web page.
I have the launching and navigating working fine.
I can write text to the web page - but the text doesn't show up in the form on the web page. I am having a hard time manipulating the form once I am there. Any help would be appreciated.
Here's what I have so far:
Dim ie As Object
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
'this will write to the web screen - just not in the form
screen = ie.document.Focus
ie.document.write ("testing the ability to send information to the i.e. screen")