excel memory overload after multiple iterations

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

Does your macro have any large values assigned to a variable through SET, you have to make sure that they equal NOTHING at the end of your script to release memory.

Please Login or Register  to view this content.

here is where i think needs improvement.

does excel hold a file in memory if i use

Please Login or Register  to view this content.

then

Please Login or Register  to view this content.

???

Please Login or Register  to view this content.

Here is what i found through other posts in Excel Forum.

HTML Code: 

Hope it leads you in the right direction.

Draconi