Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with Internet Explorer Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with Internet Explorer Problem
On Jul 30, 9:28 am, wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Internet Explorer | Excel Discussion (Misc queries) | |||
Excel/VBA/Internet Explorer | Excel Programming | |||
Internet explorer problem | Excel Discussion (Misc queries) | |||
internet explorer | Excel Discussion (Misc queries) | |||
Interacting with Explorer | Excel Programming |