Hi

I need to be able to save a workbook 800 times with a different file name each time. It will be exactly the same workbook, and would usually be a standard Save As - but is there a way i an do this automatically?

The file names would be 001, 002, 003 etc etc..

Hope you can help.

Thanks

Mark