You don't even need Windows as thisWb is a workbook object not a string. So
you just use

thisWB.Activate

this then makes that workbook the active workbook, so you can then use the
activeworkbook object, like so

ActiveWorkbook.Worksheets(1)
etc.

Or you could just use the workbook object directly

thisWB.Worksheets(1)
etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"pauluk " wrote in message
...
Thanks Bob this is ok now.

so do i just use thisWB to refernce in any code i am writting?

i.e Windows(thisWB).Activate

would i need to add anything else?

Sorry to bug you like this but it is the only real way that i am going
to learn. Beacuse of the questions i have been asking over the past few
months i am going to list all the refeneces on my site for other
newbies to use


---
Message posted from http://www.ExcelForum.com/