C
carl
sorry my fingers are tired a "h" is missing
Thanks you Isabelle.
I am using Excel2003 SP1 (11.6355.6360)
I tried to use this one (of the 2 your offerred)
Sub test2()
Dim nRow As Integer, nColumn As Integer, n As Integer
Dim sDir As String
nRow = 5
For i = 1 To 1
sDir = Range("A" & i) 'Range("A1:Ax") contains values like "c:\temp
\"
n = n + 1
For nColumn = 1 To 256
Sheets(2).Cells(n, nColumn) = ExecuteExcel4Macro _
("'" & sDir & "[MyFile.xls]ORF_Charge'!R" & nRow & "C" & nColumn
& "")
Next
Next
End Sub
The macro would prompt a window called "MyFile.xls" - it looked like
an explorer window.
What am I suppose to do at this point ?
Thanks again.