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

Application.Run "'another book2.xls'!test_msgbox"

as an example

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jorge De la Rosa" <(E-Mail Removed)> wrote in
message news:96B1CD2B-0CCC-4DCB-A48E-(E-Mail Removed)...
>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

Thank you for you help!.
It worked well
--
Jorge De la Rosa


"Bob Phillips" wrote:

> Application.Run "'another book2.xls'!test_msgbox"
>
> as an example
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Jorge De la Rosa" <(E-Mail Removed)> wrote in
> message news:96B1CD2B-0CCC-4DCB-A48E-(E-Mail Removed)...
> >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
>
>
>

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" <(E-Mail Removed)> wrote in
message news:96B1CD2B-0CCC-4DCB-A48E-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in
> message news:96B1CD2B-0CCC-4DCB-A48E-(E-Mail Removed)...
> >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
>