After that, only the workbook you are using has to be open.

The workbook which is referenced must be open; Excel will
typically open it automatically for you.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"tjtjjtjt" wrote in message
...
One way:
You can also create a Reference between the two workbooks (if
they are both
open) from the Tools Menu. To make the reference, both the
files should be
open. After that, only the workbook you are using has to be
open.

tj

"Joe" wrote:

Dear sir,
how can i call a function or procedure that contained in
another workbook ?

thanks
Joe