Focusing on open workbooks
 

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

Focusing on open workbooks
 

you can sort thru the list of currently open workbooks by

For Each w In Workbooks
windows(w.name).activate
'
' add code here to operate on active workbook
'
Nex

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=48099

Focusing on open workbooks
 

you can sort thru the list of currently open workbooks by

For Each w In Workbooks
windows(w.name).activate
'
' add code here to operate on active workbook
'
Nex

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=48099