I am using Excel 5. (Don't laugh). I am trying to set a variable in a module
in one workbook by referencing a cell in another workbook (that contains
some data). How can I do this? I tried the following and it failed.

Sub test()
Dim j As Variant

j = Evaluate("[temp.xls]sheet1!R23C4")
End Sub

this gives me an error 2015
Any help is appreciated.
Thanks,
Paul