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
 

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

Top