PDA

View Full Version : Can't get form posted



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.

JP2112
12-01-2010, 01:44 PM
Check out this thread:

http://www.vbaexpress.com/forum/showthread.php?t=35206