2/14/2023 0 Comments Openoffice calc macrosYou can run the macro in many ways, for test purposes just use the Run button on the same window that you used to create the module. To test it, just create a chart, put something as a title on the cell C1 and run the macro. OChartDoc.getTitle().String = oCell.getString() ' to get the second you would use 1, the third 2 and so on. ' Get the chart with index 0, which is the first chart created ' Get the cell containing the chart title, in this case C1 Once you create a new module the editor screen will pop up, write this code below: ' Set the title of the first Chart to the contents of C1 Go to Tools > Macros > Organize Macros > Basic, and once there add a new module under your file's tree. OpenOffice accepts a wide range of languages including Python, but since you mentioned VBA in your question I'll use OO's version of it here. Now that you can run them, you must create a new macro. Note: Be careful, if you are unlucky or live in the 90's an evil macro can cause serious damage! My settings are on low because I'm the author of all the macros I run, if you are not sure that this will be your case you might want to use a higher setting. ![]() Now on the Security Level Tab, make sure that your settings will allow you to run Macros. Once there, click the Macro Security button. Go to the Tools > Options menu and click on the Security section under. Yes it is possible, and with OpenOffice macros it is quite easy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |