Macros in Calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
Peterthegreat
Posts: 2
Joined: Sat Dec 02, 2017 11:47 pm

Macros in Calc

Post by Peterthegreat »

I'm hoping to teach myself how to write visual basic macros for Calc.
As with many programming situations the first steps are the most difficult.
I was hoping somebody could point me in the direction of examples/tutorials on exactly how to get started.
Thanks in advance
Peter
OpenOffice 4.1 on Windows 7
User avatar
RoryOF
Moderator
Posts: 34613
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Macros in Calc

Post by RoryOF »

First, stop thinking "Visual Basic". OpenOffice BASIC is different. The major sources for Macro studies in OpenOffice are the books of Andrew Pitonyak, downloadable from his site at http://www.pitonyak.org/oo.php

However, it is possible that the OpenOffice BASIC manual at
https://wiki.openoffice.org/wiki/Docume ... ASIC_Guide
will be more than adequate.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Macros in Calc

Post by Zizi64 »

http://www.pitonyak.org/oo.php

The StarBasic (the name inherited from the StarOffice) is a very simple Basic language and IDE only...

You can control the applications and the documents over by the API functions and procedures. API = Application Proramming Inteface.
You can call these functions and procedures from the StarBasic, or from the other supported programming languages.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Peterthegreat
Posts: 2
Joined: Sat Dec 02, 2017 11:47 pm

Re: Macros in Calc

Post by Peterthegreat »

Thanks to the two respondents and I've now got plenty to read.
I'm not quite sure why a somewhat political article on the European Union is relevant to this subject but now doubt all will become clear.
OpenOffice 4.1 on Windows 7
User avatar
RoryOF
Moderator
Posts: 34613
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Macros in Calc

Post by RoryOF »

I was not aware that my link to Andrew Pitonyak's site was incorrect - apologies, I have corrected it. It was a left-over link on the clipboard from an earlier email which had not been displaced by my copy from the Pitonyak site.

Once again, apologies for my error - late in the evening I often work on auto-pilot and do not always recheck my posting.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply