View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.