Hi Shyam,
Thanks for the code.
I am already doing this.
My main query is after I have made the copies, I want to rename these
files automatically with the names that I have in a list in Excel.
Regards,
Aindril
On Mar 8, 6:30 pm, rf1234 rf1234 <rfhyd1...@gmail.com> wrote:
> Hello Dear,
> Try to savecopyas
>
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> Sub Saving_A_Copy_Of_Workbook()
> Dim i, x As Integer
> Dim NewWorkbook As Workbooks
> Dim fname As Variant
> Dim bAchievedTarget As Boolean
> x = InputBox("Enter number of times to copy active sheet")
> For i = 1 To x
> MsgBox i
> Application.DisplayAlerts = False
> ActiveWorkbook.SaveCopyAs "c:\temp\i.csv"
> Next
> End Sub
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
> On Mon, Mar 8, 2010 at 1:15 PM, Andy <aind...@gmail.com> wrote:
> > Hi All,
>
> > I need some help in replicating an Excel file and make around 1000
> > copies of it. I am able to do that, using good old DOS :). However the
> > problem is I need to replicate the files and rename the files with a
> > list of predefiled file names, that I have in a worksheet in Excel.
>
> > Is there any way that I can use a VBA code to make the copies and
> > rename as per the existing list.
>
> > Thanks in advance for your help.
>
> > Regards,
> > Andy
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> >http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
