Preface: I am programming via the VBA code window of Excel 2002.
I've added Microsoft Internet controls and Microsoft HTML object library to the project references.

So far this works:

Dim web As WebBrowser
Private Sub FormLoad()
   Set web = New WebBrowser
   Set web = CreateObject("internetexplorer.application")
   web.Navigate2 "http://blahblahblah.com/"
   web.Visible = True
End Sub
Private Sub FillForm()
   web.Document.Forms(0).EMP__NO.Value = "111111"
   web.Document.Forms(0).PASSWORD.Value = "password"
End Sub

FormLoad launches IE to the appropriate web site.
FillForm fills in the 2 fields of the form.

I am stumped as to how to programmically hit the submit button. I tried adding the following line to the FillForm Sub with varying results.

web.Document.Forms(0).submit
VB is waiting for an invalid/missing method

web.Document.Forms(0).submit()
VB identifies this as a syntax error

web.Document.Forms(0).submit = True
VB states that there is an invalid method or empty value

The total program logs into a website, fills out a series of forms, generates an excel spreadsheet and pulls the data back into excel. These submit buttons are the only thing stopping the program from running.

I'll post the final code after everything is working.

Thanks in advance for any help

I'm also about to try something like this - except that after I login, I want to upload a file. I'll try your code, and see if I have any luck with the website I'm connecting to. If I can get it to work, I'll let ya know. This is pretty new to me though, so I'll probably be waiting to find your solution before I have any luck.

Tom Barthen

you can try the click() method ...

as for web.document.forms(0).buttonName.click()

please inform me if it works. [email protected]

Try using web.Document.Forms(0).submit() (not sure of the case.) This works within the javaScript on a webpage, so it should work in your VB.

Have u checked the form settings. Is there any METHOD("POST/GET") specified and ACTION value of the form.

If these values are not assigned then, It will give error.

or you can also add them into code before submit

web.Document.Forms(0).Action="<file _ name>"

web.Document.Forms(0).Method="GET/POST"

__________________
Vikash Kumar Singh