Using Open Office in lotusscript

[Lando Chez]

Hi

I have an application that opens MS word en MS excel templates. We are
going to use Open Office in the near future. Does anyone have used
lotusscript to open Open Office documents? Can someone post me that
piece of lotusscript code how to open an Open Office ( and also if
possible fill a cell or field on the template). Cause I don't have any
clue how to start.

Thanks in advance.

Regards

[Karl-Henry Martinsson]

"Lando Chez" <goodm...@hotmail.com> wrote in message
news:1192971934....@k35g2000prh.googlegroups.com...

There was a session at Lotusphere either this year or last year about this.
Perhaps you can find the presentation somewhere?

/Karl

[myanovsky]

On Oct 22, 10:41 am, "Karl-Henry Martinsson" <na...@martinsson.us>
wrote:
> "Lando Chez" <goodmin...@hotmail.com> wrote in message
>
...

>
> There was a session at Lotusphere either this year or last year about this.
> Perhaps you can find the presentation somewhere?
>
> /Karl

Hi,

I have a presentation from Lotusphere 2007, Karl mentioned in his
reply, it contains LotusScript examples you need, so if you're
interested, I can mail it to you (PDF, 750Kb). Or look at the fragment
from the presentation below regarding OpenOffice Calc integration:

Sub Click(Source As Button)
Set SM=CreateObject("com.sun.star.ServiceManager")
Set Desktop=SM.createInstance("com.sun.star.frame.Desktop")
Dim args()
Set CalcApplication=Desktop.loadComponentFromURL_
("private:factory/scalc","_blank",0,args)
Set Worksheet=CalcApplication.Sheets.getByName("Sheet1")Set
cell=Worksheet.getCellByPosition(3,6)
Call cell.setString("Hello World!")
End Sub

Best wishes,

Mathew