I'm in a bit of a pickle. I need to make sure that when one of my macros has finished running it is unloaded properly (clears everthing from memory because our systems are resource hungry) but i also need to keep a hold of certain information gathered during that macro's runnning. I'm thinking of using a temp file but I'm not to sure how to do it. as is typically the case for me, the theory is there but I have no idea about the execution.

Any help in this regard would be mostly appreciated (even a pointer to a Kb entry would help)

Thanks in advance
Andrew