I have a macro in book A that opens a workbook(book B) and runs a macro in
that workbook. I would like to return a variable set in the macro in book B
to the calling macro in Book A. Is this possible.

I know i could use a workaround by the macro in book B settiing a cell value
in book A with the required value
--
with kind regards

Spike