[dev] help to Migrate Openoffice 3.1 calc to Vb6

[jeyaraj]

Dear Sir,

                    I am Jeyaraj.R From Maduarai which in tamilnadu(India) I
am working in Tvs company we are planning to migrate MS-Office To Open
Office. We have developed Our Software Using Vb/Sql Server  we have
genereated so many mis reports using MS-office Excel with vb6.0. Now we need
the sample code for Openoffice 3.1 with Vb 6.0. How to write the data in
calc using Visual basic 6.0 ? Please send the sample code it will help to
migrate easily.

 

 

This is the sample code for Excel & Vb6 :-

 

Reference should be add Microsoft excel 11.0

 

            Set oFSO = New FileSystemObject

    Set wbXL = objXL.Workbooks.Add

    Set wsXL = objXL.ActiveSheet

    irow = 1: icol = 1

    wsXL.Cells(irow, icol).Value = "SLNO "

    wsXL.Cells(irow, icol).Font.Bold = True

    objXL.ActiveWorkbook.SaveAs "c:\aa.xls"

    wbXL.Close

    objXL.Quit

    Set wbXL = Nothing

    Set objXL = Nothing

 

So Kindly send the sample code if any reference need to add inform me.

 

 

           Thanks & Regards., 

                R.JEYARAJ

          Everything is Possible