How to call an office js function from VBA code? about office-js

[zhenhuangMSFT]

Hi @HugoAlbertoNieto, I am afraid there is no such support. I will update here if I find something.

[bhattikashif]

Hi @HugoAlbertoNieto , If your JS function is parameter less, you can register shortcut keys against your JS function and then trigger your JS function using Application.SendKeys function from VBA. But if this function requires parameters then you will need a similar approach as you have referenced to share data between VBA and JS.

[HugoAlbertoNieto]

Thanks @bhattikashif. My function requires parameters. We ended up deciding to mantain both, the VBA and the JavaScript addins at the moment. Thanks!

[bhattikashif]

Now just a week after this I got the same requirement for calling JS function from VBA code. @zhenhuangMSFT is there any chance of introducing this functionality in near future/current year?

[HugoAlbertoNieto]

@bhattikashif I would suggest you to to give a try to the JsBridge repository. After a week of research, the closest I was to make it work, was using that code.

[zhenhuangMSFT]

Hi @bhattikashif , unfortunately there will be no plan for introducing such capability officially in the short term.