1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to export data from Visual Basic to "OpenOffice.org Calc" spreadsheet?

Discussion in 'Visual Basic ( VB )' started by akn_my_183a, Aug 20, 2007.

  1. akn_my_183a

    akn_my_183a New Member

    Joined:
    Aug 20, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    Good Days,
    I have a problems exporting data from VB to "OpenOffice.org calc" spreadsheet? It is totally different from Microsoft Excel..
    Hope to get u all assistances..

    thank u very much :)
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    What is the exact problem you are facing??
     
  3. akn_my_183a

    akn_my_183a New Member

    Joined:
    Aug 20, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    the most problem i am facing is i dont know how to code it. It's unlike Microsoft Excel..

    dim oExcel as Excel.Application
    dim oWs as Excel.Worksheet
    dim 0Wb as Excel.workbook
    .
    .
    .
    .
    .

    but for OpenOffice.org calc, i dont know how to export data from VB to this kind of spreadsheet. :)
     
  4. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Create a normal Excel file, OpenOffice supports MS Excel format!
     
  5. akn_my_183a

    akn_my_183a New Member

    Joined:
    Aug 20, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    In my company, all the pc are using free software, "OpenOffice.org". Now i was assigned to create programs to generate reports. If they use Microsoft Products, i can still manage to do it. Now it's different....
     

Share This Page