ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Search a spreadsheet for words in certain fields (https://www.excelbanter.com/excel-programming/361739-search-spreadsheet-words-certain-fields.html)

campwes

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!


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com