Trying to Combine Workbooks
 

I have A Number of different workbooks with different filenames in a
single folder. All Excel files have the same heading rows, & # of
columns. Basically I want to set up a macro that will look in a
specified folder, take all the data from all files, and put them into a
Master File. I am not very experienced at programming, but this is
something that I have to do every day and this could truly help
streamline what I am doing. I am sure this can be done, just not sure
where to start. Can anyone point me in the right direction? Thanks so
much!
Ryan

Trying to Combine Workbooks
 

Try this Ryan
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
I have A Number of different workbooks with different filenames in a
single folder. All Excel files have the same heading rows, & # of
columns. Basically I want to set up a macro that will look in a
specified folder, take all the data from all files, and put them into a
Master File. I am not very experienced at programming, but this is
something that I have to do every day and this could truly help
streamline what I am doing. I am sure this can be done, just not sure
where to start. Can anyone point me in the right direction? Thanks so
much!
Ryan

Trying to Combine Workbooks
 

Ron,

That was exactly what I was looking for! Thank you very much!

Regards,

Ryan

Ron de Bruin wrote:
Try this Ryan
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
I have A Number of different workbooks with different filenames in a
single folder. All Excel files have the same heading rows, & # of
columns. Basically I want to set up a macro that will look in a
specified folder, take all the data from all files, and put them into a
Master File. I am not very experienced at programming, but this is
something that I have to do every day and this could truly help
streamline what I am doing. I am sure this can be done, just not sure
where to start. Can anyone point me in the right direction? Thanks so
much!
Ryan