I intend to work on an opened workbook using Macro in another workbook. The
code I use is:

Dim wk as Workbook
Set wk=Workbooks.open("c:\a.xls")

It works when a.xls is closed. But when it is opened. I got a messgae "The
workbook is already Opened". Does anyone know how? Thanks.
--
I like Vb.