[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

calling subs

RonFFS

12/18/2006 3:39:00 PM

Is it possible to call from one workbook, subroutines in other workbooks; if
so could you give me a code example.

many thanks
Ronffs
2 Answers

Bob Phillips

12/18/2006 3:52:00 PM

0

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"RonFFS" <RonFFS@discussions.microsoft.com> wrote in message
news:9EB8C59C-D0C5-4D93-8FD5-75452065460B@microsoft.com...
> Is it possible to call from one workbook, subroutines in other workbooks;
> if
> so could you give me a code example.
>
> many thanks
> Ronffs


RonFFS

12/19/2006 10:52:00 AM

0

HTH - yes it did; thanks - and thanks for the speedy reply. I could not find
this information under "VBA Help"

"Bob Phillips" wrote:

> Application.Run "'another book2.xls'!test_msgbox"
>
> --
> ---
> HTH
>
> Bob
>
> (change the xxxx to gmail if mailing direct)
>
>
> "RonFFS" <RonFFS@discussions.microsoft.com> wrote in message
> news:9EB8C59C-D0C5-4D93-8FD5-75452065460B@microsoft.com...
> > Is it possible to call from one workbook, subroutines in other workbooks;
> > if
> > so could you give me a code example.
> >
> > many thanks
> > Ronffs
>
>
>