Call external macro program

[cwng3]

How can I call a macro in other excel in my excal macro program ?


I know that we can use Application.Run "TEST.xls!GetDeal" but I dont wanted to "hardcode" the file name in the program. Any suggest?

I have tried to use workbook.GetDeal but it is not able to recognize the program. Any suggest?

Thanks and regards,
TT

 

[BrianB]

The argument to Run must be a string. So something like :-

    Dim MyBook As String
    Dim MyMacro As String
    MyBook = "Test.xls"
    MyMacro = MyBook & "!GetDeal"
    Application.Run MyMacro

 

[cwng3]

get it thanks.

finally, I do like this



Dim MyBook As String
Dim MyMacro As String

...

MyBook = MyBook.Name
Application.Run MyBook&"!GetDeal"