[Solved] Export Base Table to Calc

[ttt_1978]

I´m intending to create a button in a form on base database to export data from a table (using a SQL statement) to a Worksheet of Calc.
How can I open OOoCalc from Base via Macro [OOo Basic]?

[Villeroy]

Much easier: [Tutorial] Using registered datasources in Calc
You open the spreadsheet and refresh the linked data.
You open the spreadsheet (or text document), hit F4 and drag the data you need into the document

[ttt_1978]

Villeroy, thanks for your tip. It's very helpfull.
However, I'm looking for a Macro that opens the Calc via OOo Basic. Can it be done?
I want to create a button to my users that create a worksheet in Calc with a standard format and information about the database, hour and date that it will be created (just like a report).

[Villeroy]

Yes, write your macro and if you encounter concrete programming problems don't hesitate to ask again.
Is a simple click on a hyperlink pointing to a spreadsheet with linked row sets really too much effort? Is it really worth all the programming effort to reinvent built-in features?

[ttt_1978]

Well, I´m trying to migrate my Database form MSAccess to Base.
In MSAccess I could open MSExcel and generate a report, using this code:

Code: Select all

Sub Export_to_Excel()
Dim xlApp As Excel.Application
Dim xlSheet As Excel.Worksheet
Dim xlWorkbook As Excel.Workbook
Set xlApp = CreateObject("Excel.Application")
xlApp.ScreenUpdating = False
xlApp.Visible = False
Set xlWorkbook = xlApp.Workbooks.Add
Set xlSheet = xlWorkbook.Sheets(1)
...

Is there a way to do that on Base (Basic)?

[Villeroy]

You want me to write the same program again for a completely different API?
Please, do us all a favour and stay with MS Office.

[ttt_1978]

Villeroy,
If you don't want to help me, I don't care. Just don't reply this post anymore. Go away!
I just want some help of anyone that wants to help!!
My question is simple, and I didn't find it in the forum.
Maybe someone else has the answer.
I just want to know how to open Calc from Basic.
Does someone else can help me?

[RoryOF]

Start with
http://wiki.services.openoffice.org/wik ... ASIC_Guide

[FJCC]

Referring to the document RoryOF provided, check out the section Working with Documents - The StarDesktop

[ttt_1978]

Thank you!