title: Reading Data using OLEDB from opened Excel File
body: <p>I have an excel file(Lets' say File X) with 2 sheets. In first sheet I display charts. Second I have data for the chart. In order to get data from chart, I need to process that data as we do in SQL like Group by, order by. Is there any way I can use oledb to read data from second sheet using VBA code in same excel file(file X)?</p>
  
  <p>Thanks!! </p>