Clearing a Javascript Message Box from VBA

[BHo15]

This issue has been around the block more than once. I've ready quite a bit over the last couple of days, but still have not been successful.

In controlling a website, and attempting to delete all of the selected items in a table, I get a Javascript pop-up which asks me if I really want to delete all of them (OK or Cancel). When this pops up, my vba code stops, and will not do anything else, until a human clicks the button.

Here is the HTML, Javascript, and my VBA...

HTML

<p>Delete:&nbsp;<input type="button" name="button_Delete" value="Delete" onclick="doDelete('c');">&nbsp;<span class="note">Deletes all selected charts.</span></p>
                                                        <p>Move to:&nbsp;<select id="select_Lists" name="select_Lists">
                                                                <option value="trash" selected>-> Trash <-</option>
                                                                <option value="245">000-000 AEH</option>

Javascript

<a href="javascript:doDeleteList('169', 'C');">Delete List</a> |

My Code

Dim ieDelete As HTMLInputButtonElement
Set ieDelete = IE.Document.getElementsByName("button_Delete")(0)
Sleep (500)
ieDelete.removeAttribute ("onClick")
Sleep (500)
ieDelete.setAttribute "onClick", "return true;"
Sleep (500)
ieDelete.Click

I have even tried printing the onClick values in the immediate window before and after setting it, but it continues to come up...

function onclick(event)
{
doDelete('c');
}

...which pops up the message box.

While I think this sounds like a pretty good approach, I am open to anything. Thanks for looking.

[zmbd]

From what I am seeing, you are using the IE-Object, once the IEO is suspended by the message box, I think you're stuck from a VBA standpoint.

There may be an API call in the User32 library that could send the message to the window; however, that's only a guess on my part as I've not really used API calls in the past - BUT I know that some of our experts have so maybe one of them will have that knowledge.

The next option might be a shelled script using the WScript object that loops and waits for the popup... once again, not something I am really familiar with, The only reason this comes to mind is because I have used such a script to push front-ends down from the server to the user's pc so maybe there is a way to do the same for your cause.

Sorry, not much more I can do to help you.

Best of Luck
-Z