Ask Your Question
1

can I record macro that are not VBA

asked 2018-10-21 07:57:44 +0100

Sol gravatar image

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 flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-21 09:38:02 +0100

Lupp gravatar image

updated 2018-10-21 10:46:29 +0100

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.

edit flag offensive delete link more

Comments

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..

Sol gravatar imageSol ( 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.

Lupp gravatar imageLupp ( 2018-10-21 10:46:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-21 07:57:44 +0100

Seen: 42 times

Last updated: Oct 21 '18