MrExcel Publishing
Your One Stop for Excel Tips & Solutions

open workbooks

Posted by amroo on April 07, 2001 7:02 AM

I am working in a workbook nammed WB1.xls under a macro1 and I want to paste the result of my work in an another workbook nammed WB2.xls .So what is the macro's code to activate WB2 from WB1.
2001 thanks to whom help me.

Posted by Dave Hawley on April 07, 2001 2:05 PM

Hi Amroo

If the workbook is already open use:

Windows("WB2 ").Activate

Or if closed use:
Workbooks.Open Filename:="C:\My Documents\Wbk2.xls"


OzGrid Business Applications