Hello,


I'm using excell to control IE like this:

Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.navigate "<url is goes here"
Do Until ie.readyState = 4 'READYSTATE_COMPLETE:
Application.StatusBar = "Opening Network Portal... Please
Wait..."
DoEvents:
Loop

Later I have to click a submit button, however, doing it as below isn't
working

With ie.document.forms("F001") ' form name goes
in ()
..Date.Value = dt
..submit '
submit form values
End With

The date values goes into a text box that has the focus when the page
finishes loading. When the code executes the ".submit" statement IE
gives me this error:

Software error:
Can't use string ("") as a subroutine ref while "strict refs" in use
at...blah..blah


is there a way around this(preferably without using sendkeys)? If I
must change the focus to the button how do I do that?

Jim


--
jimthegunman
------------------------------------------------------------------------
jimthegunman's Profile: http://www.excelforum.com/member.php...o&userid=29728
View this thread: http://www.excelforum.com/showthread...hreadid=543184