We are a group of students trying to add a functional executable piece to writer.
So we could create a set of documents with fields that get data from a database.
[Solved] How to create a macros (wizard)
[Solved] How to create a macros (wizard)
Last edited by MrProgrammer on Fri Aug 14, 2020 12:51 am, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
Apache OpenOffice 4.1.7 Windows 10
Re: how to create a macros (wizard)
Look at the works of Andrew Pitonyak at
http://www.pitonyak.org/oo.php and http://www.pitonyak.org/database/
These will probably tell you as much as you need to know about OO macros and databases - do not miss his works on databases at the second URl.
.
http://www.pitonyak.org/oo.php and http://www.pitonyak.org/database/
These will probably tell you as much as you need to know about OO macros and databases - do not miss his works on databases at the second URl.
.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
- MrProgrammer
- Moderator
- Posts: 4905
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: how to create a macros (wizard)
Hi, and welcome to the forum.
XY Problem
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
This is exactly what Mail Merge does. Maybe you need macros; maybe not. But your project will be 20 times harder if you use macros when Mail Merge would suffice. Read about this feature in Help → Index or in User Guides (PDF) or searching for topics about it in the forum.maria947 wrote:So we could create a set of documents with fields that get data from a database.
XY Problem
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: how to create a macros (wizard)
Are you asking generally about writing macros or how to create your own wizard using:
https://www.openoffice.org/api/docs/com ... izard.html
https://www.openoffice.org/api/docs/com ... izard.html
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: how to create a macros (wizard)
Thank you all for your answers and warm welcome!MrProgrammer wrote:Hi, and welcome to the forum.
This is exactly what Mail Merge does. Maybe you need macros; maybe not. But your project will be 20 times harder if you use macros when Mail Merge would suffice. Read about this feature in Help → Index or in User Guides (PDF) or searching for topics about it in the forum.maria947 wrote:So we could create a set of documents with fields that get data from a database.
XY Problem
I asked the other members of the team for exact information.
The result of our project must be a custom Wizard that is embedded to the menu File and works as an extention.
And yes, we are already having huge difficulties with that.
I'll see if those links will help. And will return when we solve the problem)
Apache OpenOffice 4.1.7 Windows 10
Re: How to create a macros (wizard)
Hit F4.
Browse your data source in the left pane and select the right table or query.
Drag column headers into your document or template.
Once you have a template, simply create a new document from it.
Browse your data source in the left pane and select the right table or query.
Drag column headers into your document or template.
Once you have a template, simply create a new document from it.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: how to create a macros (wizard)
I saw that this topic is solved but you have not provide any solution.maria947 wrote:The result of our project must be a custom Wizard that is embedded to the menu File and works as an extention.
And yes, we are already having huge difficulties with that.
I'll see if those links will help. And will return when we solve the problem)
Could you do that?
OpenOffice 4.1.12 - Windows 10