View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
campwes campwes is offline
external usenet poster
 
Posts: 3
Default Search a spreadsheet for words in certain fields

Hi. I'd like to be able to search a spreadsheet for words in certain fields.
I have to copy data from different regions of the spreadsheet, say B1:F45
and B55:F100. There is fixed text the beginning and end of these ranges that
I can query, but I'll never know exactly how many rows exist in between in
the range. I can query the speadsheet with an OleDbDataReader (VB.NET), but
only "SELECT *...", a named range, or a range of cells specifed in the query
([Sheet1$B1:F45]).

Is what I want to do possible with ADO.NET? Thanks for the help!