Index Example

Uploaded by

csvspcal143

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as ODT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

26 views

Index Example

Uploaded by

csvspcal143

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as ODT, PDF, TXT or read online on Scribd

You are on page 1/ 2

Overview

Although OpenOffice 1.1 Calc is able to read Microsoft Excel workbooks, compatibility extends
primarily to functionality found in worksheets. Excel workbooks with Visual Basic for
Applications (VBA) macros embedded do not function in Calc, even though VBA and StarBasic
(SB) are syntactically the same. The reason Excel/VBA workbooks do not work under Calc/SB is
due ZZ the differences in the underlying object models for Excel and Calc.
The intent of this document is to show, by way of examples, how to port VBA macros accessing
Excel objects to the equivalent SB macros accessing Calc objects. This manual is written from the
perspective of an experienced Excel/VBA programmer. Hence the reader is assumed to know the
VBA language and is familiar with the MS Excel Object Model. This document is not a tutorial on
SB.
The information contained here is based on Excel 2000 and OpenOffice 1.1 object models. A
discussion covering all aspects of the Excel object model is beyond the scope of this manual. This
manual's intent is to provide sufficient examples where the reader can get started in porting VBA to
SB and to point the reader to other references for more complete information.
This manual is a living document and is expected to be updated as more experience is gained. The
reader should feel free to contact the author to suggest areas to expand this document.

Copyright and trademark information

The contents of this Documentation are subject to the Public Documentation License, Version 1.0
(the "License"); you may only use this Documentation if you comply with the terms of this License.
A copy of the License is available at:
http://www.openoffice.org/licenses/PDL.html
The Original Documentation is Porting Excel/VBA to Calc/StarBasic. The Initial Writer(s) of the
Original Documentation is/are James M. Thompson © 2004. All Rights Reserved. (Initial Writer
contact(s): masato12610@openoffice.org.)
Contributor(s):
Portions created by are Copyright © All Rights Reserved.
(Contributor contact(s): .
All trademarks within this guide belong to legitimate owners.

Feedback
Please direct any comments or suggestions about this document to:
dev@documentation.openoffice.org and masato12610@openoffice.org
Acknowledgments
First, thank you to all the folks posting and responding on the various mailing lists and forums.
These exchanges formed the basis for several examples found in this manual. Second, I'd like to
thank the following individuals who took time out of their busy schedule to suggest changes to
improve the document's readability and the code efficiency: dfrench, Geoff Farrell, Ian Laurenson,
Andrew Pitonyak and Juergen Schmidt. Lastly, I'd like to express my sincerest thank you to my
wife, Nora, for her patience and allowing me the time to work on this manual.

Alphabetical Index
Andrew Pitonyak........................................................................................................................................2
OpenOffice.................................................................................................................................................1