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
Bookmarks