Page 1 of 1

Macros in Calc

Posted: Sat Dec 02, 2017 11:56 pm
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

Re: Macros in Calc

Posted: Sun Dec 03, 2017 12:01 am
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.

Re: Macros in Calc

Posted: Sun Dec 03, 2017 12:27 am
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.

Re: Macros in Calc

Posted: Sun Dec 03, 2017 10:42 am
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.

Re: Macros in Calc

Posted: Sun Dec 03, 2017 11:22 am
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.