Quote Originally Posted by iori
i am trying to read a value from a closed workbook in my function as follows: 


strg = "'C:\DSM\[user.xls]Sheet1'!R1C1" 
check = ExecuteExcel4Macro(strg) 
If (Err.Number <> 0) Then 
                MsgBox (Err.Description) 
End If

but ths is giving me error for some reason. I cant seem to find out the problem. can anyone plz help
http://vbcity.com/forums/topic.asp?tid=68838 might help.
---