Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: mohannad on February 15, 2022, 10:03:01 pm

Title: Excel COM Object works with JScript but not with Javascript
Post by: mohannad on February 15, 2022, 10:03:01 pm

I'm getting this error when i'm trying to create Excel COM Object for a script written javascript :

(https://i.ibb.co/BTxMVjS/err.png)

but it's working fine within a jscript, any ideas why?

Title: Re: Excel COM Object works with JScript but not with Javascript
Post by: Geert Bellekens on February 15, 2022, 10:14:13 pm

The have another syntax to do that.

Ther are a few posts on this forum about that.

Geert

Title: Re: Excel COM Object works with JScript but not with Javascript
Post by: mohannad on February 15, 2022, 10:36:52 pm

Quote from: Geert Bellekens on February 15, 2022, 10:14:13 pm

The have another syntax to do that.

Ther are a few posts on this forum about that.

Geert

Hello Geert,

I know that Javascript uses another API (which is the one in the snapshot). Also, I'm sure that this is the correct syntax since using other PorgId(s) works fine.
For instance, If I replace the excel progId with "WScript.shell" it works just fine. So, I thought this might be related to this particular application.

Thanks