How to pass JavaScript variable in ExcelVBA (Web Automation)

Question

I'm currently doing some web automation. My recent problem is to pass content to tinymce text area with excel VBA. After searching all over the internet, I think the possible answer can be found here: How can I pass variable parameters into a Javascript Function using Excel VBA.

However, I tried to do the same as mentioned in above link but failed.

IE.Document.parentWindow.execScript "tinyMCE.get('Server').setContent(" & inputStr & ")", "JavaScript"

Currently, the variable inputStr was declared in VBA as below:

With dataSheet
inputStr = .Range("B35").Value
End With

Does the variable need to be declared as javascript variable? If so, how I can do that in excel VBA?

Please help.

QHarr · Accepted Answer · 2018-06-21 10:55:31Z

0

You would not declare as a javascript variable as it would be passed using VBA.

As it is a string variable you would do

Dim inputStr As String

answered Jun 21, 2018 at 10:09

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

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

1 Answer 1