Calling Subs in other WB
 

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.

Calling Subs in other WB
 

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.

Calling Subs in other WB
 

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.

Calling Subs in other WB
 

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.

Calling Subs in other WB
 

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.