merging files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maaz - 28 Feb 2007 14:06 GMT

there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.

Reply to this Message

Ron de Bruin - 28 Feb 2007 14:43 GMT

Hi Maaz

See
http://www.rondebruin.nl/copy3.htm

Or one of the other examples on my site

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> there is a folder containing 400 excel files which are on same pattern. I
> want to merge all files in a single new excel file.

Reply to this Message

Maaz - 01 Mar 2007 13:05 GMT

i am new user i didnt know about amcros would please tell me about macros
from start

> Hi Maaz
>
[quoted text clipped - 5 lines]
> > there is a folder containing 400 excel files which are on same pattern. I
> > want to merge all files in a single new excel file.

Reply to this Message

Ron de Bruin - 01 Mar 2007 16:24 GMT

Start here

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And post back if you need more help

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>i am new user i didnt know about amcros would please tell me about macros
> from start
[quoted text clipped - 8 lines]
>> > there is a folder containing 400 excel files which are on same pattern. I
>> > want to merge all files in a single new excel file.

Reply to this Message