J
jimthegunman
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
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