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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Luanch a browser, fill in a field, puke.

Status
Not open for further replies.

natureboy

Programmer
Jun 16, 2003
12
0
0
US
Can somebody please help...I'm running the following code to launch a web browser and fill in a field with a path, but I get "Object variable not Set" error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
URL = "
ActiveWorkbook.FollowHyperlink Address:=URL, NewWindow:=True, AddHistory:=True

Dim oie As Object
Set oie = CreateObject("InternetExplorer.Application")
oie.navigate (URL)
oie.Document.forms.Item(1).elements.Item(2).Value = "c:\temp"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
What am I doing wrong?

Thanks in advance.

G
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top