Call / Run a Macro from another Workbook

[Irish_Griffin]

Hi Everyone,
Here is an interesting problem.

Within VBA, I want to open an existing workbook and call/run macros found in this newly opened workbook.

With searching, I found the following code to run a macro from a different workbook :

Dim File_Path as string
Dim File_Name as string

File_Path = "C:\test.xls"
File_Name = "test.xls"

Workbooks.OpenText Filename:=File_Path

Application.Run File_Name & "!macro_name_here"

My problem is this :
I need to pass variables into the macro found in the other workbook

thus the following code does not work :

Application.Run File_Name & "!macro_name_here(string_var, boolean_var)"

Is there a solution ???

Many Thanks,
Griff

 

[Andrew Poulsom]

Did you try eg?

Application.Run File_Name & "!macro_name_here(string_var, boolean_var)", Arg1, Arg2

where Arg1 and Arg2 are variables containing arguments 1 and 2.

 

[Irish_Griffin]

Solved, I was just a couple Googles away

Application.Run File_Name & "!macro_name_here", string_var, Boolean_Var

Friday is Tomorrow !!!! WOOT for the weekend !!!

Peace,
Griff

 

[Irish_Griffin]

Did you try eg?

Application.Run File_Name & "!macro_name_here(string_var, boolean_var)", Arg1, Arg2

where Arg1 and Arg2 are variables containing arguments 1 and 2.

Thanks Andrew !!!