run code in other workbook
 

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

run code in other workbook
 

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

run code in other workbook
 

I think that should read...

Application.Run "answers.xls!Pastry"

I think you need the file extension....
OJ

run code in other workbook
 

thanks both. that's great!
"OJ" wrote in message
ups.com...
I think that should read...

Application.Run "answers.xls!Pastry"

I think you need the file extension....
OJ