Macros in Calc

Creating a macro - Writing a Script - Using the API

Macros in Calc

Postby Peterthegreat » Sat Dec 02, 2017 11:56 pm

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
Peterthegreat
 
Posts: 2
Joined: Sat Dec 02, 2017 11:47 pm

Re: Macros in Calc

Postby RoryOF » Sun Dec 03, 2017 12:01 am

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/Documentation/BASIC_Guide
will be more than adequate.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25492
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Macros in Calc

Postby Zizi64 » Sun Dec 03, 2017 12:27 am

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; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6061
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Macros in Calc

Postby Peterthegreat » Sun Dec 03, 2017 10:42 am

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
Peterthegreat
 
Posts: 2
Joined: Sat Dec 02, 2017 11:47 pm

Re: Macros in Calc

Postby RoryOF » Sun Dec 03, 2017 11:22 am

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.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25492
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests