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
Macros in Calc
-
- Posts: 2
- Joined: Sat Dec 02, 2017 11:47 pm
Macros in Calc
OpenOffice 4.1 on Windows 7
Re: Macros in Calc
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.
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
Re: Macros in Calc
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.
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.
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.
-
- Posts: 2
- Joined: Sat Dec 02, 2017 11:47 pm
Re: Macros in Calc
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.
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
Re: Macros in Calc
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.
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