How to call a JavaScript function from a VBA Script

Asked Aug 17 '20 at 14:35

Active Aug 19 '20 at 07:02

Viewed 596 times

I want to pass paramaters from VBA to a JavaScript function and then return the result back to the VBA script. At first my JavaScript Function could look like this:

function myFunction(p1, p2) {
  return p1 * p2;   
}

My question is, if there is any command in VBA to solve this problem.

For the final setup, I want to use Node.js with Selenium to get some Information and send it back to VBA.

I know there are a lot of threads with similar question but I just dont get smart out of them. Many people use "execScript method". Can this be applied to my problem?

Thanks for your help.

edited Aug 19 '20 at 07:02

asked Aug 17 '20 at 14:35

maja95

*Where* is the JS function? - in a string/file, or in a webbrowser control ... – Alex K. Aug 17 '20 at 14:55
The function is in a file. – maja95 Aug 18 '20 at 05:14
1

Assuming Windows you can use an instance of the `ScriptControl` as shown here: https://stackoverflow.com/questions/62166109/64-bit-excel-vba-to-call-a-javascript-function/62166671#62166671 – Tim Williams Aug 18 '20 at 05:37
1

...and read the file content using (eg) built-in file functions or maybe Scrripting.FileSystemObject – Tim Williams Aug 18 '20 at 05:39

How to call a JavaScript function from a VBA Script

0 Answers0