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
> 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
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
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
>
>
Hello Dear,
Try to savecopyas
'''
Sub Saving_A_Copy_Of_Workbook()
Dim i,
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