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

  • Thread starter Thread starter Enjoy Spain
  • Start date Start date
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
 
Try this tiny macro:

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