Sub VBALibrary Rem Sub openWorkbooks (iFiles ()) Rem Dim wBook as Workbook Rem Dim wList as String Rem Dim iFile as String Rem Rem For Each iFile in iFiles Rem Workbooks. I simply don't have the time to try to learn the entire API just so I can understand one portion of it-especially since I'd have to learn C++ just so I could understand the syntax used in the documentation. Go to the menu and click on Tools -> Macros -> Organize Macros -> Basic. I've found a number of pages that give bits and pieces of info, but they're either terribly incomplete or they assume a comprehensive pre-existing knowledge of the UNO API. Since I can't run interactively, I can't really interrogate that variable to learn about it. In addition, there's no information about XSCRIPTCONTEXT, which OOo apparently provides as a global variable. It says nothing about the API, how to search for and modify cells, etc.

I already know about ' Python as a Macro Language,' but it only answers where to put Python files. From the reading I've done, it appears that I can't set up a dynamic environment from where I can examine the appropriate object(s) themselves, so I'll have to rely solely on documentation. Once there, click the Macro Security button.

The trouble is, I can't find any useful documentation on how to write Python macros. Go to the Tools > Options menu and click on the Security section under. Since I don't know OpenOffice Basic and have no desire to learn it, I'd like to write my macro in Python. I'm trying to make a macro for OpenOffice Calc that will toggle the background color of cells containing a user-specified value.

Openoffice calc macros