If the macro MyMacro is in Module1 of a workbook named Book1.xls then from
another workbook you could do

Application.Run "Book1.xls!MyMacro"

someone else showed you how to reference cells in the other workbook.

--
Regards,
Tom Ogilvy


"zoot" wrote:

Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run it
in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help