Vlookup not working in xls file

[bintoca]

I had used the vlookup formula

ActiveCell.FormulaR1C1 = _
"= IF(VLOOKUP(RC1,'[Item Details.xlsb]Sheet1'!R1C1:R" & sTotalrowItemdetails & "C" & sTotalColumnsItemdetails & ",1,1)<>RC1,0, VLOOKUP(RC1,'[Item Details.xlsb]Sheet1'!C1:C" & sTotalColumnsItemdetails & ",R1C,1))"


This is working perfect in all other excel format except xls.


Pls help.....

[Ariff_Chowdhury]

"=if(vlookup(r1c1,,,,,,,