I am current writting a VB .Net app that needs to do the following:
open an existing excel workbook and select a worksheet
search the cells in one column for a string
continue searching the cells in the same column for another string
copy the cells between both strings and push them into a db
I've having difficulty finguring out how to search the cells into order to create the range object, w/o creating the range object to begin wth.
I haven't worked with the Excel object model before so any assistance would be appreciated