Posted to microsoft.public.excel.programming
|
|
Calling procedures of a different project
Thanks for your help. I already try this way and work fine.
--
Jorge De la Rosa
"Chip Pearson" wrote:
Another method is to set a reference from the workbook that needs to call
the function to the workbook that contains the function. In the VBA editor,
open the workbook that contains the functions. Go to the Tools menu and
choose "VBA Project Properties". In that dialog, change the name from
"VBAProject"
to something meaningful, like "MyFunctions". Save that workbook. Then open
the workbook that is going call upon the functions, go to the Tools menu,
choose References, and select "MyFunctions" in the list.
Once you have that reference in place, you can call functions in the
"MyFunctions" project as if they were native VBA functions, without any
qualifiers.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"Jorge De la Rosa" wrote in
message ...
I have different VBA procedures in different workbooks and I need to call a
procedure from one workbook to another. How can I do this? How is the
right
syntaxis?
I appreciate any help.
--
Jorge De la Rosa
|