>Hi,
>
>When using Excel automation, say I want to get values from a range of cells (e.g. A3 to G200), how do you do it? I mean, one cell at a time. I think it would involve setting FOR NEXT but I can't think of how to do it for letters of the cell.
>
>TIA for any suggestions.

loRange = oExcel.ActiveWorkBook.ActiveSheet.Range("A3:G200")

for row = 1 to loRange.Rows.Count
  for col = 1 to loRange.Columns.Count
    luValue = loRange.Cells( m.row, m.col ).Value
  endfor
endfor

Cetin

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad