Hello, I am trying to migrate fr

[Katto]

Hello,

I am trying to migrate from Microsoft Office to OpenOffice.

I am trying to do the following in VBS for the PowerPoint equivalent Impress:

open an impress presentation.
add a slide
add a text on the slide
import a picture on the same slide
I could not find any relevant information just by googling

Note: VBS not VBA

Thank you

 

[Don Child]

Hi Katto,

I haven't worked with Open Office/VBScript, but the best forum is probably

https://forum.openoffice.org/en/forum/index.php

There's an Impress subforum there.


Here's some introductory explanation, although they aren't specifically about Impress:

https://www.openoffice.org/udk/common/man/tutorial/office_automation.html

https://wiki.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Bridge/Automation_Bridge

Is Presentation the same thing as Impress? If so, then this would be directly relevant:

https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Presentations

 

[Katto]

thanks,
I checked that website. it didn't answer my question

 

[Rick998]

1. OpenOffice has fallen far behind LibreOffice. (Many OpenOffice developers jumped ship to LibreOffice when Oracle stopped development and gave OpenOffice to the Apache Foundation.)

2. Neither OpenOffice nor LibreOffice support VBS (nor VBA). Internal scripting support for LibreOffice is limited to:
[ul]
[li]LibreOffice Basic[/li]
[li]JavaScript[/li]
[li]BeanShell[/li]
[li]Python[/li]
[/ul]

3. Neither OpenOffice nor LibreOffice support the use of the built-in macro recorder in any component other than Writer and Calc so all Basic scripts have to be hand-written.

Hope this helps...

 

[Katto]

ok, then assuming I am in LibreOffice Calc with BASIC, how do I:

open an impress presentation.
add a slide
add a text on the slide
import a picture on the same slide

 

[Rick998]

Before I retired I worked for a huge local council that tried for nearly 6 years to transition from MS Office to first StarOffice then OpenOffice many years ago... and gave up. Our Power Users just couldn't come to terms with the lack of scripting support, including documentation. The council went back to MS Office.

I can't help. You'll need help.libreoffice.org and specialised OpenOffice/LibreOffice forums, not this VBS forum... nor any other Tek-Tips forum.

If you look for Impress > Macros in the LibreOffice wiki you'll see it has a grand total of 2 listed. Documentation is not LibreOffice's strong point, mainly because its developers are nuts'n'bolts, under-the-hood sort of people and the organisation has not yet attracted or yet seen the need for (or cannot afford) additional support personnel like documenters/tutorial writers.

You'll get a better understanding from articles like Writing Macro in LibreOffice Impress – Getting Started and Change Impress Layout at Runtime Using Basic Macro but, again, there's only 2 articles there.

There's just no correlation between Basic and VBA that I can see - let alone VBS - so you're going to have to start with the basics like How to start writing macros in LibreOffice Basic and build from there.

To answer your question specifically, you are better off asking at ask.libreoffice.org, not here You'll probably get better help there than from anywhere else.

Hope this helps...

 

[Katto]

thank you!
I'll try to follow your advice