Reading the contents of a Cell from a closed Workbook

[Lorgach]

Hi All,
I am new to writing Excel VB Macros so I hope this is not too silly a question.
I have looked at the archived Q & A's and can only find answers to this that involve quite a few lines of Code.
Is there any way to read the contents of a single Cell from a CLOSED Workbook that you know the name and location of, by using a single line of Code?
eg. Read the Data in Cell 'A1' on Sheet 'Sheet1' in Workbook 'Test-1.xls'.

I have tried to modify the Code that I got from
http://j-walk.com/ss/excel/tips/tip82.htm

VariXXX = ExecuteExcel4Macro("'C:\TestFolder\[TestWorkBook.xls]TestSheet'!$A$1")

I have also tried other variations of this but with no success.
Any help would be appreciated.

Thanks in Advance

 

[Andrew Poulsom]

This worked for me:

Sub Test()
    VariXXX = ExecuteExcel4Macro("'C:\TestFolder\[TestWorkBook.xls]TestSheet'!R1C1")
    MsgBox VariXXX
End Sub

Note the R1C1 style.

 

[Lorgach]

Thanks very much Andrew.
It seems so simple now when I see it.
I had tried everything except the 'R1C1' instead of 'A1" for the Cell location.
I suppose knowledge will come with experience.
Best Regards.