# can I record macro that are not VBA

OK so it seems macros are now VBA style, is there still the old style of macro language similar to Excel V4 Macro functions that can be used in LO?

Ron

edit retag close merge delete

Sort by » oldest newest most voted

I don't know MS Excel V4, but it was released 1992, Thus its macro recorder may have been something like a key logger.

Anyway, LibreOffice comes with a macro language which is a specific Basic enriched by some predefined variables giving access to the needed objects (StarDesktop and the current document mainly). The relevant functionality is provided via an elaborate API. This did never change substantially since LibO exists at all. The OpenOffice.org of which LibreOffice branched off in 2010 came with the same Basic and API.

In parallel there are some 5000 so called slots, kind of little prefab routines which can be called and supplied with arguments by the DispatchHelper. It's exclusively this kind of routines used by the macro recorder. No interactions with control elements are recorded. To make a recorded macro usable with parameters adapted to specific cases, you need to edit and complete it manually after recording.

more

Yes, I do think it basically was a key logger for some aspects but there were many macros that I could type in to do specific functions and to the right, I could type what it was doing..

( 2018-10-21 10:01:25 +0100 )edit

Hmmm, I already told I don't know Excel 4, but at that time (up to about 1997) I used MS Works for a while, and did a lot of "macro enhancing" for macros recorded with that software. That's what I took my estimates from.

( 2018-10-21 10:46:09 +0100 )edit