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 and
paste it to another sheet.

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


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=480994