View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
todtown todtown is offline
external usenet poster
 
Posts: 35
Default Using ADO to get data from Worksheet in Same Workbook

Here is an easy one for somebody. I have a workbook where one of the
worksheets contains columns of data and another worksheet is a summary
of that data. I can use formulas in the summary sheet. I can also use
something like EVALUATE(FORMULA) in VBA. But, is it possible to use
ADO to connect to the Data sheet and populate the Summary sheet using
queries against that data?

tod