Bob Ewers wrote:
Is it possible to activate this workbook without opening it in the current session of Excel.

Simple answer: no.

More complicated answer: maybe - if you used API calls to find other instances of Excel and
then use Automation to see if any of them have Test1.xls open. I don't have details of any
suitable API calls with me.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup