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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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