Try

Application.Run "answers!pastry"

"Saladin" wrote:

Hi

I can open a second workbook in code but can not manage to run a proc within
the second book (from the first book). I've made second book code Public.
Something like workbooks("answers.xls").pastry doesn't work (where pastry is
Public proc). Does this make sense?

How to please?

Thanks!
Graeme