VBA for running javascript in IE

Question

I am tyring to run JavaScript through VBA in Excel.

IE.document.parentWindow.execScript "javascript:__doPostBack('ctl00$ContentPlaceHolder1$GridView1','Edit$0')"

The above code works fine.

I am tyring to click another link through following code which is running a JavaScript. But I am getting an "expected end of statement" error.

IE.document.parentWindow.execScript "javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ContentPlaceHolder1$GridView1$ctl02$ctl00", "", true, "", "", false, true))"

I have also tried using double quotes " like

""ctl00$ContentPlaceHolder1$GridView1$ctl02$ctl00""

The error has gone but it did not run the script.

The command that works uses single quotes. The one that doesn't is using double quotes. Have you tried single quotes? — Dave
– Dave, Commented Aug 25, 2017 at 9:10
I got it. The existing code is IE.document.parentWindow.execScript "javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ContentPlaceHolder1$GridView1$ctl02$ctl00", "", true, "", "", false, true))" Now the working code is IE.document.parentWindow.execScript "javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions(""ctl00$ContentPlaceHolder1$GridView1$ctl02$ctl00"", """", true, """", """, false, true))" -All the string arguments shall be within additional double quotes! Thank You All — VEERAMANI K
– VEERAMANI K, Commented Aug 26, 2017 at 16:28

Raymond Wu · Accepted Answer · 2021-09-16 12:47:38Z

1

I got it. The existing code is

IE.document.parentWindow.execScript "javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ContentPlaceHolder1$GridView1‌$ctl02$ctl00", "", true, "", "", false, true))"

Now the working code is

IE.document.parentWindow.execScript "javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions(""ctl00$ContentPlaceHolder1$GridView‌1$ctl02$ctl00"", """", true, """", """, false, true))"

-All the string arguments shall be within additional double quotes! Thank You All

edited Sep 16, 2021 at 12:47

Raymond Wu

3,4272 gold badges9 silver badges20 bronze badges

answered Aug 26, 2017 at 16:34

VEERAMANI K

194 bronze badges

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

Collectives™ on Stack Overflow

VBA for running javascript in IE

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