Show javascript alert with VBA

Question

I have managed to open IE via excel and navigate with it, but i am not able to run basic JS functions like "alert" or "prompt". (in browser, not MsgBox in excel) I have tried:

appIE.document.onLoad = "function() { alert(""text"");};"

Any idea?

You can only attach that handler to an existing document, which by definition has already loaded, so you're not going to see an alert from that. Have you tried attaching an event to an element in the document after it has loaded? I think also that last semi-colon is not required. — Tim Williams
– Tim Williams, Commented Nov 26, 2013 at 19:14
This was the only solution i could think of, is there any way i could show an alert on the webpage instead of excel? (regardless if it is an event or not) — Adam Voga
– Adam Voga, Commented Nov 26, 2013 at 19:19

Tim Williams · Accepted Answer · 2013-11-26 19:25:11Z

6

appIE.document.parentWindow.execScript "alert('text');", "jscript"

answered Nov 26, 2013 at 19:25

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Show javascript alert with VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related