I have a macro which is using filesystemobjects and the readline, writeline method. The general purpose of the macro is to convert anything with a non-standard date format to be standard.
When the size of the file to be analysed goes above 300Mb, the readline function has used so much of the PC's memory that it keeps swapping between conventional and virtual memory slowing the macro down to a crawl.
Is there any way of flushing system memory between writes and reads to reduce the memory requirement?
When the size of the file to be analysed goes above 300Mb, the readline function has used so much of the PC's memory that it keeps swapping between conventional and virtual memory slowing the macro down to a crawl.
Is there any way of flushing system memory between writes and reads to reduce the memory requirement?
