I have a fairly simple, but heavy-duty macro that does simple changes to a docx then stores the docx. But I am looping over 100k+ documents divided into 8 subdirectories to make use of multiple user profiles running in parallel. The loop of course is defined in the macro, I am not repeatedly calling soffice processes to life. It seems that around the 60k mark the process dies without warning, closing all applications except terminal windows along with it, which I am safely assuming is a memory thing. Is there any macro command that I can use to free up memory let’s say every 10k iterations?
The simplest solution is to limit the number of documents processed by the macro in one call and close LO when the quota is reached. It may also be useful to move already processed documents to another folder.
1 Like