[calc] Macros: What command to add to exit a macro?

[davetheraveuk]

I have a macro that when run from the command line does not exit Calc.
How do I run the macro from the CLI and exit?

Thanks.
Dave

[mikekaganski]

How to run a single macro for all excel files

First: your recorded macro wouldn’t work: it doesn’t apply changes, it just opens a dialog. Please always test recorded macros You may use this macro instead: Sub FitToPage Dim document As Object, pageStyles As Object document = ThisComponent pageStyles = document.StyleFamilies.getByName("PageStyles") For i = 0 To document.Sheets.Count - 1 Dim sheet As Object, style As Object sheet = document.Sheets(i) style = pageStyles.getByName(sheet.PageStyle) style…

[davetheraveuk]

Would the following work?

dispatcher.executeDispatch(document, “.uno:Save”, “”, 0, Array())