This one may be a bit tricky, but I am hoping someone will know the answer.
I have used this Function that I got from a book to retrive values from closed books with VBA

Function GetValue(Path, File, Sheet, ref)
Dim Arg As String
Arg = "'" & Path & "[" & File & "]" & Sheet & "'!" & Range(ref).Address(, , xlR1C1)
GetValue = ExecuteExcel4Macro(Arg)
End Function

It is basically building the formula for a lined cell, but when getting values in VBA it saves me having to open the book get the value and then close the book again. I would use a procedure like the one below to get it to pass back the value

sub GetData
dim dummy
dummy = getvalue("C:\work\","Accounts.xls","2005","A1")
end sub

What I would like to be able to do is pass it the row and column numbers rather than "A1"

Hence dummy = getvalue("C:\work\","Accounts.xls","2005",1,1)
would give me the same answer

Does anyone know what the "& Range(ref).Address(, , xlR1C1)" part of the function would need to be in order to accomplish this? Any help would be very much appreciated.

or you could change
Function GetValue(Path, File, Sheet, ref)

to Function GetValue(Path, File, Sheet, refRow, RefCol)

Then Change Range(ref).Address(, , xlR1C1) to
cells(refRow,RefCol).Address(, , xlR1C1)

Is that what your after

Dave

Many thanks David.

This little tip has saved me hours/days of trial and error

Michael