How can I pass variable parameters into a Javascript Function using Excel VBA (2)

Question

Well based on the post: The same as this one

I've tryed to do this:

Call mFramePesquisa.parentWindow.execScript("gotoPage(pesquisa.html?re_ligacao)", "JavaScript")

As you can see the js function takes one parameter "pesquisa.html?re_licagao" but when executed on the browser it gives an error saying that ":" was expected.

So i've tryed to quote the function parameter without success:

Call mFramePesquisa.parentWindow.execScript("gotoPage(" & chr(34) & "pesquisa.html?re_ligacao" & chr(34) & ")", "JavaScript")

or

Call mFramePesquisa.parentWindow.execScript("gotoPage('pesquisa.html?re_ligacao')", "JavaScript")

Both throw out an "Object expected" error on ie browser.

Any suggestions?

thx

PS: I've tried also to use chr(63) instead of "?" but without success.

Edit: I suspect it had something to do with the string used as parameter, since in the original JS the function is called like this on a onChange evento for a object:

onchange=javascript:gotoPage(this.value)

gotoPage('pesquisa.html?re_ligacao') should work fine, but requires a function called gotoPage to be defined in the page. Try this instead: "window.location.href = 'pesquisa.html?re_ligacao';" — user447356
– user447356, Commented Dec 13, 2010 at 20:58
Yes, the gotoPage is defined on the document. And the window.location.href gives me the same error (":" was expected) — Paulo Bueno
– Paulo Bueno, Commented Dec 14, 2010 at 10:44

Tim Williams · Accepted Answer · 2010-12-14 21:14:41Z

1

This worked for me in a test page:

IE.document.parentWindow.execScript "RunMe(""hello"")", "jscript"

Tim

answered Dec 14, 2010 at 21:14

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

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

1 Comment

Paulo Bueno Over a year ago

It worked!! Thanks! Anyway i've found that i was referencing the wrong document object since i'm working on a 5 level nested frame html document.

Collectives™ on Stack Overflow

How can I pass variable parameters into a Javascript Function using Excel VBA (2)

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related