You can use Application.Run. E.g.,

Applicaiton.Run "Workbook1.xls!TheSub
' or
Result = Application.Run ("Workbook1!TheFunction,1,2,3)


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


"Joe" wrote in message
...
Dear sir,
how can i call a function or procedure that contained in
another workbook ?

thanks
Joe