Calling Subs in other WB

G

Guest

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.
 
G

Guest

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
 
G

Guest

It's not a private sub. Thanks though.

Halim said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Handling Problem calling Macro from Other Worksheet 6
Getting the name & path of a hidden WB 2
Run subroutines in other workbooks? 4
Code to delete names works in one WB, but not another WB? 2
help with VBA program to import and add formatted files to one file 0
closing another file by code causes failure to run workbook activate event 2
Multi-word WB name 5
calling sub from other workbook 1

Top