in reply to
Re: Out of memory and While replacements with excel XLSX application
in thread Out of memory and While replacements with excel XLSX application
This answer was the first one I succefully implemeted. It was a solution to the original question of how to avoid a "out of memory" return, while still writing to .XLSX files. Thanks to the poster.
The total system memory use never exceeded 4GB as before and the total runtime seemed unchanged.
I will test some the other solutions to see if the runtime can be optimized through better coding on my part.