Make a backup of the folder with a date time stamp is a option
http://www.rondebruin.nl/folder.htm

Try

Sub Copy_Folder()

And use this in the code

'If you want to create a backup of your folder every time you run this macro
'you can create a unique folder with a Date/Time stamp.
'ToPath = "C:\" & Format(Now, "dd-mmm-yy h-mm-ss")


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Aidan Engineer" wrote in message
...
At present every time I run my software package the output file overwrites
the previous one (as they have the same name). Is there any way of setting up
my folder so that instead of overwriting the previous file the new file gets
a number appended to it, hence keeping both the new and previous file.
i.e. previous file name = test
new file name = test(1)
etc..

Any help would be greatly appreciated.