Referencing Call to Another Project
Hi Phil.,
Try:
Application.Run "OtherBook.xls!MacroName"
See Run in VBA help for more details.
---
Regards,
Norman
"Phil B" wrote in message
...
Hello
I am working on a VBA project where I would like to call a procedure from
another project (workbook). First, does the project (workbook) need to be
open , and even when open I am having trouble referencing the call to the
procedure. I realize I can just copy the procedure into the current
workbook, but it is a procedure I realized may be useful in other projects
and thought I would put it into personal.xls and simply call it when
needed from there. I'm sure its possible to Call it, but I think I'm just
hung up on the correct reference syntax. Any help appreciated.
Phil B.
|