>Hi
>
>I want to read excel file which has many sheets from my visual foxpro prog.
>Depedning on values in certain cell of excel sheet I want to update fields of fox table. I also ant to know how to read certain range e.g. from b2:b500. How can I read cell values using from within loop. i.e. I don't want to hard code my prog. Can I do this from Foxpro.
>
>Thanks in Advance.
>
>
>Ashish Patel

Ashish,
You could loop in range. ie:

lcXLSFile = 'c:\path\YourXls.xls'
lcRange = "b2:b500"
oExcel = createobject("excel.application")
With oExcel
  .Workbooks.open(lcXLSFile)
  With .ActiveWorkbook.ActiveSheet.range(lcRange)
    For ix = 1 to .Rows.count
      For jx = 1 to .Columns.count
        ? .Cells(ix,jx).Value
      Endfor
    Endfor
  Endwith
  .quit
Endwith

However if your range is big, keep in mind looping in Excel with VBA is very slow. Instead you could just get a copy of sheet as type fox2x and process a dbf.
Cetin