read from .ods spreadsheet

zizi21 used Ask the Experts™

I have a spreadsheet in .ods format and I am trying to read the columns and display it perhaps in another open office document. I am trying to use a macro to do so.

Any help to get me started is appreciated. Thanks.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
what application are your trying to run the macro from ?

ODS is OpenOffice / LibreOffice format.  So not easily accessible from VBA.


hi there, i was able to open the macro in openoffice spreadsheet. The code is written in visual basic. I was to close this question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial