Not able to run Javascript in Excel VBA

[jkrafka]

I am trying to run Javascript code inside Excel VBA...

I did add the "Microsoft Script Control 1.0" library...
When I run this code:
Dim vbsObj As New ScriptControl
vbsObj.Language = "JScript"

the execution stops in line 2 with error:
"Runtime error 2147221164 (80040154) Class not registered"

I have also run command line: Regsvr32.exe "C:\Windows\SysWOW64\msscript.ocx"
and it registers successfully but the error continues to show.
Any insights? is there other way to run Javascript? thank you.

[mogul]

As far as I know this is a 32-bit COM addin and only works Windows 32-bit.

[jkrafka]

thanks mogul for your answer ... does this mean I can only run Javascript in a Win32 ? I really cant believe this is not possible in Win64. Is there another way of doing this?

[Marc L]

Hi,

try in late binding mode so without the need of any additional reference like in this thread
and in case of same result then this ActiveX can't work under Excel 64 bits version like many other …

[mogul]

Why do you need to run Javascript. Javascript runs in a browser.