How I create lots of copies of the same document in once?

E

Enjoy Spain

I have an excel file and I must create many times the same document to
be filled by the clients.
I must create at least 600 copies of the same document?
Is there any way to do it in once, instead to copy the document one by
one?
Regards
Alberto
 
G

Gary''s Student

Try this tiny macro:

Sub Macro1()
For i = 1 To 600
ActiveWorkbook.SaveAs Filename:="C:\test\alberto" & i & ".xls"
Next
End Sub
 
Top