Had a query while coding VBA in excel. I am working on automating the inputs given to a web page in IE and auto clicking the submit button to order reports. I am ordering a report from a webpage (restricted access). I provide three inputs and press Submit button. The on click event of the submit button redirects to a js function (UISubmitButton()). Inside the js function the second line is confirm ("Submit?"). So when the dialog box pops up it just stays on. There is no way the focus is returning to the code. function UISubmitButton() { if (lProcessing == true) return; lProcessing = true; if (confirm("Submit?")) {....} How can i click Ok by default from VBA? Any pointers on how to automate this part would be really helpful.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Automate javascript Confirm("Submit?") through VBA

Thread starter ramesh110289
Start date Sep 7, 2016

ramesh110289

New Member

Sep 7, 2016

Had a query while coding VBA in excel. I am working on automating the inputs given to a web page in IE and auto clicking the submit button to order reports.

I am ordering a report from a webpage (restricted access). I provide three inputs and press Submit button. The on click event of the submit button redirects to a js function (UISubmitButton()).

<input type="button" id="UI_SubmitButton" value="Submit" class="ReportUIButton" *******="UISubmitButton()">

Inside the js function the second line is confirm ("Submit?"). So when the dialog box pops up it just stays on. There is no way the focus is returning to the code.

function UISubmitButton() {
if (lProcessing == true) return;
lProcessing = true;

if (confirm("Submit?")) {....}

How can i click Ok by default from VBA?

Any pointers on how to automate this part would be really helpful.