Have Geek Brain

Does MS Excel use macros internally?

I've always wondered if any of the actions we do will actually translate into VBA macros before they are done. Is this how we can record macros? If not, would you call this design overkill? Will it be faster / slower, is it not like it is now?

+1


a source to share


1 answer


No, they are not translated. What's happening is that most of the UI commands execute the same code as VBA commands.

Also, VBA is not directly executed, but the code is first converted to byte code, a compact form of code that allows you to quickly search for which compiled procedure to call.



In recent years, with much more powerful computers, I have repeatedly played around with the idea of ​​turning an application into a huge library for a scripting language, and then implemented an interface with a specified scripting language that would allow for the ultimate personalization of the application.

Unfortunately, people still stick to the idea of ​​making user interfaces in XML or C ++ than Python or LUA, which are much faster to write and modify. Can you say, "It has always been this way"?

+1


a source






More articles:


All Articles