On Fri October 13 2006 23:05, Andreas wrote:
> Hi,
>
> is there a documentation that describes how I could remote control OOo
> by other Windows applications e.g. like MS-Access?
>
> I maintain an Access VBA application that manages our contacts and
> produces receipts.
> It automatically creates letters to our costomers via some VBA magic and
> MSWord and Excel objects.
>
> Now I'm trying to figure out how I could OOo teach the same tricks to
> get rid of the old Office 2000 stuff.
> For now I want to keep Access but get a grip on the OOo API.
>
> For Writer I need to open documents, connect them to specific
> query-objects, within Access then print the mailing out.
> BTW AFAIK OOo does serial letters as a single document for every
> receipient. Is it possible to have all resulting letters glued together
> in one document as Word does it as default?
>
> For Calc I'd need to create new sheets, feed data in it, format, save
> and print it. With Excel this is pretty trivial.
>
> So ... is there a HowTo or can someone at least tell me which
> libraries I have to connect in Access' VBA-IDE ?
You are probabaly looking for the programmers mailing list at
[EMAIL PROTECTED]
Another possibility is to generate an ODT file (it is after all just a Zipped
set of XML files) and then pass this file to OpenOffice.org for printing.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
