Have u opened the work book before storing the value in any variable?
Try following code  for ur problem, and then see wht happen?

Dim a as string
Dim filepath as string
filepath = "C:\"
a="Fixed.xls"
workbooks.open(filepath & a)
x= workbooks(a).Worksheets(1).Cells(i,2).value