search

sancarn / VbaJsBridge

Send messages between VBA and OfficeJS, execute code dynamically, interact with COM and more!
MIT License
11 stars 5 forks source link

TS->VBA #1

Open amoljaynadtodkar opened 3 months ago

amoljaynadtodkar commented 3 months ago

Hi. This is a really good implementation. Were you able to get a reverse workaround, Where the TS can communicate to the VBA script

sancarn commented 3 months ago

Hello,

I had a few ideas but never got around to implementing any of them. You might be able to use a HTTP server written in VBA. Something like stdHTTPServer - this is subject to change though

DecimalTurn commented 1 month ago

The HTTP server is certainly a cleaner approach, but for simple communications in Excel, using the VBA events can be a solution as well. See for example : https://stackoverflow.com/a/58002206/5958842