sir i am karhik,
from madurai, india
i am not able to open the xcel file using vb coding in Open office,

how to open the xcel file using vb in OpenOffice
please help me sir

karthik

We cover Microsoft Visual Basic in this newsgroup. Whatever equivalent
OpenOffice has would need to be discussed in a different group or Web forum,
but I don't have any idea which one.

karthik.
Assuming you mean to open OpenOffice from a VB6 app:

Private Sub Command1_Click()
Dim objServiceManager As Object
Dim objDesktop As Object
Dim objDocument As Object

Set objServiceManager = CreateObject("com.sun.star.ServiceManager")
'Create the Desktop
Set objDesktop =
objServiceManager.createInstance("com.sun.star.frame.Desktop")
'Open a new empty calc document
Dim args()
Set objDocument = objDesktop.loadComponentFromURL("private:factory/scalc",
"_blank", 0, args)
End Sub

It would probably help you to download the SDK:
http://download.openoffice.org/680/sdk.html

I'm no OO expert, but as a word of advise, you could have found all this in
2 seconds of a Google for "openoffice vb"

If you are looking to open Excel files from within OpenOffice, then you
would have to ask elsewhere as their macro language, though BASIC, is not
compatible with VB/VBA. Try the macro recorder and see what you get.

NickHK

Show quoteHide quote

MS, Enough is Enough!
Can someone please check my code? No Intellisense for items
About The Hard Disk Serial Number
Searching a string
Form.Printform
Convert Variant String to Double
Creating an ActiveX control
WHERE clause in ADO query of Excel data
Lock Word window?
FrontPage