Hi
Thanks Sir, Thats great.
Regards,
Kapil Gupta
On Tuesday, April 22, 2014 11:32:48 AM UTC+5:30, Abhi wrote:
>
> Dear Kapil,
>
> Please see the attached.
>
> This will create workbooks, paste filtered data and save them as per the
> name column (Col G).
>
> *Keep in mind the following:*
>
[mailto:excel-macros@googlegroups.com] On
Behalf Of Ganesh N
Sent: Tuesday, April 22, 2014 12:02 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need new Workbook create using Macros
Hi Ravinder sir,
Can you please explain about the collections and below line of code how
Hi Ravinder sir,
Can you please explain about the collections and below line of code how it
works ? Becoz im not familiar with collections
For i = 2 To ws.Range("g1").End(xlDown).Row
col.Add ws.Range("g" & i), CStr(ws.Range("g" & i))
Thanks & Regards,
Ganesh N
On Tue, Apr 22, 2014 at 11:52 AM,
Hi Gupta,
Please find the attachment.
Thanks & Regards,
Ganesh N
On Tue, Apr 22, 2014 at 11:43 AM, Ravinder wrote:
> Pfa,…first click on button and then select where u want to save file.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *kapi
Pfa,…first click on button and then select where u want to save file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of kapil Gupta
Sent: Monday, April 21, 2014 8:48 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need new Workbook create us
Dear Kapil,
Please see the attached.
This will create workbooks, paste filtered data and save them as per the
name column (Col G).
*Keep in mind the following:*
a) The new excel files will be created in the same folder* where you have
saved this file*. So, when you download this, save it in a f
