GO: How to compile a Go DLL to work with it in VBA?

Question

go

Good afternoon, how to correctly compile a library in GO for further use of its functions in VBA. Does anyone have a working example?

Answer 1

Ask a question about how to work with variables, the formats of strings or the same lists are different.
If anything, VBS can only use COM objects. For the sake of curiosity, I googled, and did not find how to create those from GO, there are examples of only use.
My advice to you is that using such different tools in itself is something out of the ordinary, should not be the norm and should be avoided as much as possible. Not in the sense that COM is bad, it was just created as a tool for your task, but in the fact that you will become very limited in terms of using tools, namely windows, i.e. yes COM is bad.
Arrange interprocessor communication through serialization and sockets. Disadvantages - serialization overhead (use google protoboof it is probably not there only for something like brainfuck, and I'm not sure, and it's an order of magnitude faster than the usual json / xml / ...), advantages - independence and separation of tasks, in In the future, you will be able to remake every module in any other language/platform, and separating processes across machines will help scale the system a bit.

Answer 2

you need to create a regular dll. And then import it into VBA in the usual way. Then use like regular functions