Problem executing a macro in another open Workbook 1

[Zac5]

I want to execute a macro called "Main" held in second workbook from macro in current workbook

current workbook snippet is as follows:

Dim second_wb As Workbook
Set second_wb = ActiveWorkbook

Application.Run (second_wb!Main)

Above line fails, I think I have the syntax wrong, any ideas please, thanks in advance.

 

[PHV]

Have you tried this ?
Application.Run second_wb.Name & "!Main"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Zac5]

Its a somewhat better result, however now I get a "run-time error 1004: The macro 'second macro.xls!Main' cannot be found"

Could it be that the macro is not enabled when the second workbook is opened through the primary macro - no idea???

 

[PHV]

You really have an embedded space in your workbook's name ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Zac5]

Hi PHV,

Yes there is a space in the workbook's name. Any ideas?

Thanks.

 

[PHV]

Perhaps this ?

Application.Run "'" & second_wb.Name & "'!Main"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bong]

How can "second_wb" be your ActiveWorkbook? Wouldn't that just make "second_wb" your current workbook?

_________________
Bob Rashkin

 

[Zac5]

PHV - Tried putting it in quotes as you said, but now gives a run-time error '424' Object required at the same place.

Bob - I don't think what you are suggesting is causing the problem, thanks nevertheless.

 

[Zac5]

Hi PHV,

Apologies, your last post that recommeded adding the quotes has resolved it. I made a small mistake with the quotes whilst adding them.

Thanks a lot for your help once again!