Reading from two cells in an excel spreadsheet

[tydee]

i need to read data from excel and store it in a database(SQL server 2005).I am doing this using vb.While reading i need to keep track of values fro two positions in excel.(ie two diffrent cells or ranges) how do i go about this.

 

[Frink]

Hallo,

Try something like:

  Dim objExcel As Object
  Dim objSpreadsheet As Object
  Set objExcel = CreateObject("Excel.Application")
  objExcel.Workbooks.Open "C:\MySpreadsheet.xls"
  objSpreadsheet = objExcel.Workbooks(1).WorkSheets(2) 'Or whatever
  Debug.Print "Cell at Row=3, Col=4 on Worksheet=2, Wookbook=1 is " & objSpreadsheet.cells(3, 4))

From that you should be able to look up how to do ranges.

- Frink