Calling Subs in other WB

's Computer Specifications

I'm trying to have a macro run a sub in another workbook, but I keep getting
an error. I use:

Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"

but it tells me it can't be found. The wb is open and there are no typos.

's Computer Specifications

Hi,

Try it this way:

Application.Run "'FAMOUS Intermediate.xls'!LinksToValues_All"

--
Hope that helps.

Vergel Adriano

"san-avsc" wrote:

> I'm trying to have a macro run a sub in another workbook, but I keep getting
> an error. I use:
>
> Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"
>
> but it tells me it can't be found. The wb is open and there are no typos.

's Computer Specifications

Hi san,

Could you check wether sub LinksToValues_All is not a private sub in
workbook 'FAMOUS Intermediate.xls' module.?

Change private sub to sub
--

Regards,

Halim

"Vergel Adriano" wrote:

> Hi,
>
> Try it this way:
>
> Application.Run "'FAMOUS Intermediate.xls'!LinksToValues_All"
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "san-avsc" wrote:
>
> > I'm trying to have a macro run a sub in another workbook, but I keep getting
> > an error. I use:
> >
> > Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"
> >
> > but it tells me it can't be found. The wb is open and there are no typos.

's Computer Specifications

It's not a private sub. Thanks though.

"Halim" wrote:

> Hi san,
>
> Could you check wether sub LinksToValues_All is not a private sub in
> workbook 'FAMOUS Intermediate.xls' module.?
>
> Change private sub to sub
> --
>
> Regards,
>
> Halim
>
>
> "Vergel Adriano" wrote:
>
> > Hi,
> >
> > Try it this way:
> >
> > Application.Run "'FAMOUS Intermediate.xls'!LinksToValues_All"
> >
> >
> > --
> > Hope that helps.
> >
> > Vergel Adriano
> >
> >
> > "san-avsc" wrote:
> >
> > > I'm trying to have a macro run a sub in another workbook, but I keep getting
> > > an error. I use:
> > >
> > > Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"
> > >
> > > but it tells me it can't be found. The wb is open and there are no typos.

's Computer Specifications

That did it - thanks!

"Vergel Adriano" wrote:

> Hi,
>
> Try it this way:
>
> Application.Run "'FAMOUS Intermediate.xls'!LinksToValues_All"
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "san-avsc" wrote:
>
> > I'm trying to have a macro run a sub in another workbook, but I keep getting
> > an error. I use:
> >
> > Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"
> >
> > but it tells me it can't be found. The wb is open and there are no typos.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: calling subs	Bob Phillips	Microsoft Excel Programming	0	18th Dec 2006 03:51 PM
Calling public subs	ST	Microsoft VB .NET	4	29th Oct 2004 02:18 PM
calling subs	Mike	Microsoft Excel Programming	4	8th Apr 2004 08:22 PM
calling Subs	Jacques Proot	Microsoft Access VBA Modules	1	12th Sep 2003 04:01 PM
Re: Calling Subs	TC	Microsoft Access Form Coding	0	4th Aug 2003 04:34 AM