Hi ,

I am a set of excel files in a folder . I want to open every excel file in
the folder and then open another excel workbook with some formats and paste
the contents to the template , the script then needs to save this in another
folder and then quit. Any help in this would be great..
--
Rohan Patnaik

Hi Rohan.

Ron de Bruin has an extensive range of sample code at:

Ron's Excel Tips
http://www.rondebruin.nl/tips.htm

See, for example:

Merge data from all workbooks in a folder(Dir)
http://www.rondebruin.nl/copy3.htm

and

Merge data from all workbooks in a folder(FSO)
http://www.rondebruin.nl/fso.htm


---
Regards,
Norman


"Rohan" <(E-Mail Removed)> wrote in message
news:6B6F3F40-9736-4288-9D93-(E-Mail Removed)...
> Hi ,
>
> I am a set of excel files in a folder . I want to open every excel file in
> the folder and then open another excel workbook with some formats and
> paste
> the contents to the template , the script then needs to save this in
> another
> folder and then quit. Any help in this would be great..
> --
> Rohan Patnaik

Thanks a lot Norman this was really helpful..

Regards,
Rohan
--
Rohan Patnaik


"Norman Jones" wrote:

> Hi Rohan.
>
> Ron de Bruin has an extensive range of sample code at:
>
> Ron's Excel Tips
> http://www.rondebruin.nl/tips.htm
>
> See, for example:
>
> Merge data from all workbooks in a folder(Dir)
> http://www.rondebruin.nl/copy3.htm
>
> and
>
> Merge data from all workbooks in a folder(FSO)
> http://www.rondebruin.nl/fso.htm
>
>
> ---
> Regards,
> Norman
>
>
> "Rohan" <(E-Mail Removed)> wrote in message
> news:6B6F3F40-9736-4288-9D93-(E-Mail Removed)...
> > Hi ,
> >
> > I am a set of excel files in a folder . I want to open every excel file in
> > the folder and then open another excel workbook with some formats and
> > paste
> > the contents to the template , the script then needs to save this in
> > another
> > folder and then quit. Any help in this would be great..
> > --
> > Rohan Patnaik
>
>
>