SaveCopyAs - holding onto file handle

[cgoatly]

Hi,

I'm having a problem with a piece of code that I have written. See below.
The code creates files in paritcular folders, but each time it is run the computer seems to hold onto the last file that was created. This means that when I try to delete the files(as I am testing the code), the computer refuses to delete the last file that was created. I figured that I need to close the file in the code, but this doesn't seem to work as I am doing a savecopyas from a template file. The reason I am doing this is that I want to keep the template file open with its original name ready for another loop through the code. Does anyone know how I can sort this problem out?

Please Login or Register  to view this content.

Many thanks,
C

[mrice]

Try having a final line

Please Login or Register  to view this content.

to close any file.

It may also be worth having the same line at the start of your code to clear up any opened files.