Hi Todd, :-)
You can use Application.ExecuteExcel4Macro, something like..


Code:
--------------------

Sub Test1()
Dim strTarget As String
strTarget = "'" & "CHANGE HERE TO FULL PATH to Book2.xls" & "\[Book2.xls]Sheet4'!R6C1"
Selection.Value = Application.ExecuteExcel4Macro(strTarget)
End Sub

--------------------



---
Message posted from http://www.ExcelForum.com/