[users] open file

[Arie Bor]

L.S.

 

To open a file in calc, I use this post on the web forum. 

How to read from a calc doc - OOBasic macro

 
<http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=23841&sta
rt=0>
http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=23841&star
t=0

 

I fond 2 methods. Both do not work.

 

sub h5

Dim doc As Object, docURL As String

Dim opts(0) As New com.sun.star.beans.PropertyValue

opts(0).Name = "Hidden"

opts(0).Value = True

docURL = ConvertToURL("D:\tabela.ods")

doc = StarDesktop.loadComponentFromURL(docURL, "_blank", 0, opts() )   RUN
TIME ERROR

MsgBox("OK")

doc.close(True)

end sub

 

  variantURL = "file:///C:/variantDoc.ods"

  variantDoc = StarDesktop.loadComponentFromURL( variantURL, "_hidden", 0,
dummy )

 

sub h4

 

'  variantURL = "file:///C:/variantDoc.ods"

'  variantDoc = StarDesktop.loadComponentFromURL( variantURL, "_hidden", 0,
dummy )

dim tabela As Object, variantURL As String

' variantURL = "file:///D:/tabela.ods"

 variantURL = "file:///D:\tabela.ods"

 tabela = StarDesktop.loadComponentFromURL( variantURL, "_hidden", 0, dummy
)  RUN TIME ERROR

end sub

 

I use Openoffice 3.2 non profit

 

What is going wrong?

 

Arie Bor