Ubuntu

writing VB macros for open office spreadsheets

Asked by oldmoldy

I am looking for documentation that will help me to migrate VBA application code (procedures, functions, subroutines written to enhance EXCEL spreadsheets ) so that they can work with the Open Office equivalent tools. Many of the VBA applications rely on Microsoft "Application" objects which I can't find an Open Office equivalent for.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
Ralph Janke
Solved:
Last query:
Last reply:
Revision history for this message
Ralph Janke (txwikinger) said : 		#1

Here are lots of howtos:

http://documentation.openoffice.org/HOW_TO/index.html

i.e.

http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf

I hope this helps.

Revision history for this message
oldmoldy (donmoldover) said : 		#2

Thanks. This is the kind of thing I was looking for.

Don.

txwikinger wrote:

>Your question #4554 on Ubuntu changed:
>https://answers.launchpad.net/ubuntu/+ticket/4554
>
> Status: Open => Answered
>
>txwikinger proposed the following answer:
>Here are lots of howtos:
>
>http://documentation.openoffice.org/HOW_TO/index.html
>
>i.e.
>
>http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf
>
>I hope this helps.
>
>_______________________________________________________________________
>If this answers your question, please go to the following page to let us
>know that it is solved:
>https://answers.launchpad.net/ubuntu/+ticket/4554/+confirm?answer_id=0
>
>If you still need help, you can reply to this email or go to the
>following page to enter your feedback:
>https://answers.launchpad.net/ubuntu/+ticket/4554
>
>
>
>

Revision history for this message
Best Ralph Janke (txwikinger) said : 		#3

Could you please mark this question as solved?

Thanks

Revision history for this message
oldmoldy (donmoldover) said : 		#4

Right on target!