However, the information contained in this book is sold without warranty, either express or implied. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.Įvery effort has been made in the preparation of this book to ensure the accuracy of the information presented. Learn Spreadsheet Macro Programming OOoBasic and Calc AutomationĪll rights reserved. Index Learn Spreadsheet Macro Programming Dr Mark Alexander Bain Importing an Excel Spreadsheet that Contains Macros

Running Macros Automatically when Calc OpensĪdding Macros to the Calc Menu Using a Global Library to Automate OOo Calc Making Macros and Dialogs Available to Everyone Importing an Historical CSV File from Yahoo! FinanceĬomparing Companies within Yahoo! Finance Inserting a Simple Chart into a Spreadsheet Registering the Database as an OOo Data Source Optimizing Column Widths across a Whole Worksheet The Most Basic Formatting-Column and Row Dimensions List of Everything You Want to Know About UNOsĪccessing Existing Named Worksheets and Cells Opening and Closing Spreadsheets AutomaticallyĪ Real Example: Using the Table UNO to Access a Cell Subroutines and Functions in Different Libraries Using Libraries in a Multi-User EnvironmentĪdding a Library to the Macros Area Libraries, Modules, Subroutines, and Functions Learn Spreadsheet Macro Programmingĭownloading the Example Code for the BookĢ.

Openoffice excel space engineers