Interacting with Internet Explorer Problem

[jeff.kimble]

Hi, everyone. I have a macro in Excel that takes user inputs in Excel
and copies them into a form on a web page. I am having trouble
"clicking" on a button on the web page. I tried the following code to
find the button on the page:

For Each l In ie.Document.Links
Debug.Print l.Address
Next l

This code only finds the buttons at the top of the page and the bottom
of the page (i.e, it can't find buttons in the middle section/form).

The html shows the button I am interested in as:

"...onclick="submitForm('DefaultFormName',1,
{'_FORM_SUBMIT_BUTTON':'addrow'});return false">..."

This button adds a row to the form on the web page.

Does anyone have ideas on how I can click this button view VBA in
Excel?

Thanks in advance!
jk

 

[jeff.kimble]

Hi, everyone. I have a macro in Excel that takes user inputs in Excel
and copies them into a form on a web page. I am having trouble
"clicking" on a button on the web page. I tried the following code to
find the button on the page:

For Each l In ie.Document.Links
Debug.Print l.Address
Next l

This code only finds the buttons at the top of the page and the bottom
of the page (i.e, it can't find buttons in the middle section/form).

The html shows the button I am interested in as:

"...onclick="submitForm('DefaultFormName',1,
{'_FORM_SUBMIT_BUTTON':'addrow'});return false">..."

This button adds a row to the form on the web page.

Does anyone have ideas on how I can click this button view VBA in
Excel?

Thanks in advance!
jk

I wanted to clarify the code above... The for loop is actually

For Each l In ie.Document.Links
Debug.Print l.innerText
Next l

Thanks,
jk