About ExecuteExcel4Macro

[feipezi]

Hi,
Can I get (extract) a Range (multiple cell) using ExecuteExcel4Macro like what I can get by the following function:

Function GetValuesFromAClosedWorkbook(fPath, fName, sName, c_Rng, b_Rng As String)
With ActiveSheet.Range(b_Rng)
.FormulaArray = "='" & fPath & "\[" & fName & "]" & sName & "'!" & c_Rng
.Value = .Value
End With
End Function

I tried but the built-in macro did not work.
Thanks in advance.
John Z.