Hello,

i have a macro which opens a template and a source file, copies the information out of the source file into the template in a formatted way then closes the source file and uses the "saveas" command on the template to save and rename the file.

this then loops, after about 200 iterations it crashes. i have noticed by having the task manager open that the memory creeps up with ever iteration (maybe by about the same amout as the template size (8mb)).

does the saveas command then application.close clear the file from memory? or would it be more likely i have memory leakage within my code?

thanks