Using VB6 to export from access database to OO spreadsheet

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
beish1
Posts: 1
Joined: Tue May 13, 2008 12:47 am

Using VB6 to export from access database to OO spreadsheet

Post by beish1 »

Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? 2.4
What Operating System (version) are you using? XP Pro
What is your question or comment?
    Does anyone have Visual Basic 6 sample code for exporting from a recordset (Access database) to an OpenOffice spreadsheet?
    User avatar
    Hagar Delest
    Moderator
    Posts: 32627
    Joined: Sun Oct 07, 2007 9:07 pm
    Location: France

    Re: Using VB6 to export from access database to OO spreadsheet

    Post by Hagar Delest »

    I was doing some house cleaning when I found your post.

    So no, this is the wrong forum since VB and OOo basic are not compatible. You shuold ask in a MS Office forum.

    Good luck.
    LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
    User avatar
    Villeroy
    Volunteer
    Posts: 31269
    Joined: Mon Oct 08, 2007 1:35 am
    Location: Germany

    Re: Using VB6 to export from access database to OO spreadsheet

    Post by Villeroy »

    Hagar de l'Est wrote:I was doing some house cleaning when I found your post.

    So no, this is the wrong forum since VB and OOo basic are not compatible. You shuold ask in a MS Office forum.

    Good luck.
    In VB and VBA you can write programs to control both office suites.
    Programming OpenOffice.org with Visual Basic

    Anyway, programming is not required to link sheet-cells with Access recordsets.
    Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
    Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
    TerryE
    Volunteer
    Posts: 1402
    Joined: Sat Oct 06, 2007 10:13 pm
    Location: UK

    Re: Using VB6 to export from access database to OO spreadsheet

    Post by TerryE »

    Villeroy wrote:Anyway, programming is not required to link sheet-cells with Access recordsets.
    Awww, Villeroy don't be cruel. Give the guy a hint about what you mean.

    Try this one: http://user.services.openoffice.org/en/ ... f=9&t=1530. There are others.
    Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
    Post Reply