Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-12 Thread Abhishek Jain
Parag, Please elaborate what data you want to pick and where ? Suggestion: Please post new queries by creating new email. Best regards, AJ On Fri, Mar 12, 2010 at 5:51 PM, Parag wrote: > Hi, > im attaching 2 file can anyone help me to conditional vlookup, i want to > the data frm data1 f

RE: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-12 Thread Dave Bonallack
> Subject: Re: $$Excel-Macros$$ Create Multiple copies of the same file and > rename as per a list > From: aind...@gmail.com > To: excel-macros@googlegroups.com > > Hi Shyam, > Thanks for the code. > I am already doing this. > My main query is after I have made th

Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-11 Thread rf1234 rf1234
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 wrote: > Hi Shyam, > Thanks for the code. > I am alread

Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-11 Thread Andy
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 wrote: > Hello Dear, > Try to savecopyas > >

Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-08 Thread rf1234 rf1234
Hello Dear, Try to savecopyas ''' Sub Saving_A_Copy_Of_Workbook() Dim i,

$$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

2010-03-07 Thread Andy
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 w