Office Word Macro Language

I recently found out that I can create Office Word macros with Visual Basic, but can I use a different language? Visual Basic is suitable for beginners, but I want to know if different languages ​​can be used and how to configure them.

PS: Is this even possible? I love Lua. I would not look like anything. I would be a good macro language.

+4
source share
1 answer

This related question is a good example of using lua with Excel. It actually contains a lot of documentation on how to speak lua / Excel.

You cannot directly work with other languages ​​in Excel, as you can VBA. However, many languages ​​have the ability to create COM objects (for example, in the example above) that allow you to interact with Excel in the same way as in VBA. Here's a Python package that does the same.

But if you want to basically write lua code in the VBA editor and "change the language", then no, you cannot.

+2
source

Source: https://habr.com/ru/post/1501087/


All Articles