Dear Aindril
Thanks For Confirmation,Try to read the range suppose a1:a100
(the value which will be takes place as file name).
then try to save as with loop.
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Mar 11, 2010 at 3:41 PM, Andy <aind...@gmail.com> wrote:
> 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
>
--
Thanks Regards
Shyam
Software Engineer
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
--
----------------------------------------------------------------------------------
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
