how can I focus on a specified open workbook?

I have written some code that opens 10 of them.
I need to then select each one in turn to copy a range of data an
paste it to another sheet.

I just cant seem to work out how to select a workbook..

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=48099