Connect to data source macro

karlgren · Newbie Joined: 20 Jan 2005 Posts: 1

Hi all

I'm new to macro programming in OOo. I've understood that one can program a macro to
configure the data source connection.

We have about 400 working stations and not all of the users know a lot about data.
So I need the -sxw to connect the data source connection when they open the -sxw
document. If the data source is not configured, I need the macro to do it.

I have a text document placed on f:/documents/ called template_letter.sxw
The data source is placed on f:/datasource/template_letter.dbf

The user then write direct in the data source window over the document and then
print the letter. If it's possible, the best way would be to have a form popup with
the data source fields and write in this, like in MS word. And in MS Word the data
source connection is saved with the .doc document.

Is there any way to clean the data source with the info with out deleting others
data in the data source. Some one else would likely use it at the same time.

Thx
//Micke Question

Zarius · Posted: Thu Jan 27, 2005 4:33 am Post subject:

This thread (on setting up a datasource via macros) may help.

Tojan · General User Joined: 18 Jan 2005 Posts: 5

I had simimlar problem.
i wanted OO to feed from some spreadsheets, but the problems was that you had to open those manually. I wanted it to open specified files.

Was it changed in newer versions?
_________________
Web hosting deal | Praca | | job | Ebay

Liliana_mcm · Posted: Mon Feb 07, 2005 2:31 am Post subject:

Hi,

Maybe this link will help :

http://api.openoffice.org/docs/DevelopersGuide/Database/Database.htm

Liliana Matos