×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Hello, I am trying to migrate fr

Hello, I am trying to migrate fr

Hello, I am trying to migrate fr

(OP)
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

RE: Hello, I am trying to migrate fr

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...
https://wiki.openoffice.org/wiki/Documentation/Dev...

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

https://wiki.openoffice.org/wiki/Documentation/BAS...


RE: Hello, I am trying to migrate fr

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

RE: Hello, I am trying to migrate fr

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:
  • LibreOffice Basic
  • JavaScript
  • BeanShell
  • Python
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...

RE: Hello, I am trying to migrate fr

(OP)
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

RE: Hello, I am trying to migrate fr

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...

RE: Hello, I am trying to migrate fr

(OP)
thank you!
I'll try to follow your advice

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close