merging excel books
 

Hi,
Does anyone know of a way to merge multiple excel books that will be a
single sheet per book into one file - i can name them in any format and
they will all be in the same directory. Thanks, Ben


--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=542548

merging excel books
 

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


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


"bm4466" wrote in message
...

Hi,
Does anyone know of a way to merge multiple excel books that will be a
single sheet per book into one file - i can name them in any format and
they will all be in the same directory. Thanks, Ben


--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=542548

merging excel books
 

Thanks a lot, that is exactly what i needed. Just one question - if
only want to choose certain rows to be copied - say rows 20-25, how d
i go about doing that? Sorry...I'm pretty new to this.
Thanks, Be

--
bm446
-----------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...fo&userid=3394
View this thread: http://www.excelforum.com/showthread.php?threadid=54254

merging excel books
 

You can use the range example with

Set sourceRange = mybook.Worksheets(1).Range("A20:IV25")


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


"bm4466" wrote in message
...

Thanks a lot, that is exactly what i needed. Just one question - if i
only want to choose certain rows to be copied - say rows 20-25, how do
i go about doing that? Sorry...I'm pretty new to this.
Thanks, Ben


--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=542548