Using LibreOffice with VB6
Using LibreOffice with VB6
Visual Basic is designed to be used with other MS applications such as Excel by virtue of the addition of various references.
However, no such facilities are provided for free Office packages such as OpenOffice or LibreOffice.
This section provides information on how to use VB6 with LibreOffice and a set of procedures and functions based on this information. Whilst these are written for VB 6.0, as this is all I have, I imagine that they can easily be translated to the versions released after 1998 and the various Net versions.
The package consists of the set of files listed below. The VB6 project hasn't been compiled so that you can make your own edits,
| Section | Files | Notes |
|---|---|---|
| VB6 Project | LOT.vbp | This hasn't been compiled. |
| LOT.vbw | ||
| LOT.exe | This only exist for data for the help 'About' | |
| LOT_main.frm | ||
| LOT_main.bas | ||
| LOT_ss.bas | ||
| About.frm | ||
| about_64.cls | ||
| LCDC_class.cls | ||
| samples.ods | Sample data for examples | |
| samples.ots | Template for data file | |
| samples_bu.ods | Back-up of sample data | |
| Associated graphic files | ||
| Help system | help.htm | This gives an outline of the code required and descriptions of the examples. |
| opener1.htm | ||
| opener2.htm | ||
| opener3.htm | ||
| Associated graphic files | ||
| Associated CSS files | ||
| Associated scripts |
The files can be downloaded as an .ZIP document, (LO_VB6.zip, 259K)