First time here? Check out the FAQ!
asked 2012-02-18 12:39:01 +0200Dhaval
method for exporting data from Visual basic to libreoffice calc format.
right now we are using Set objExcel = CreateObject("excel.application") for msoffice output, we want it to libreoffice format.
answered 2012-02-28 20:09:42 +0200Olivier
If this statement means to create a new empty Excel file, then the equivalent in LibreOffice BASIC is
sURL = "private:factory/scalc" objCalc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, Array())
It will create an empty Calc file, acessible by objCalc object.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-18 12:39:01 +0200
Seen: 932 times
Last updated: Feb 28 '12