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