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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top