Jim.h
11-13-2010, 08:25 PM
I have a form that I can't get posted. I can get all the data in the fields correctly, but I can't get the form to submit correctly. I am using Excel 2003/IE 6
The submit button is an image only, and has the following code (names changed to protect the guilty!):
<input type="image" src="images/btn_somename.gif" border="0" align="top" onclick="document.dohickimus.cmd.value='submit_new_dohicki_mus';"/>
I've tried the following code variants to get this to go:
1)
'nextnextURL = "linkhttps://bxtweb.company.org/rtrsweb/controller.do?cmd=submit_xxx_this_thing"
'With appIE
'.Navigate nextnextURL
'End With
2)
With appIE
.Document.getElementById("link").Focus
.Document.getElementById("link").Click
End With
(no name, so I can't find it)
3)
Sendkeys "{ENTER}"
4)
With appIE.form(0).submit (all variations)
It's a work project and is driving me nuts. Any ideas how to get this to go?
Thanks.
The submit button is an image only, and has the following code (names changed to protect the guilty!):
<input type="image" src="images/btn_somename.gif" border="0" align="top" onclick="document.dohickimus.cmd.value='submit_new_dohicki_mus';"/>
I've tried the following code variants to get this to go:
1)
'nextnextURL = "linkhttps://bxtweb.company.org/rtrsweb/controller.do?cmd=submit_xxx_this_thing"
'With appIE
'.Navigate nextnextURL
'End With
2)
With appIE
.Document.getElementById("link").Focus
.Document.getElementById("link").Click
End With
(no name, so I can't find it)
3)
Sendkeys "{ENTER}"
4)
With appIE.form(0).submit (all variations)
It's a work project and is driving me nuts. Any ideas how to get this to go?
Thanks.