Is the workbook in the same instance of Excel? If so, you would have to
automate that instance. Otherwise, if in the same instance than the
approach would be:

workbooks("t0983102.xls").worksheets(1).copy
After:=Activeworkbooks.worksheets(ActiveWorkbook.w orksheets.Count)

--
Regards,
Tom Ogilvy

"John" wrote in message
...
I would like to copy a worksheet from an open workbook to my current
workbook. How do I activate a workbook that is open in another window?
Windows("t0983102.xls").Activate doesn't work...