Excel in VB through OLE

I am trying to use Excel through OLE within my application.

When I pick the data from the database through VB, I can
easily send it to Excel WorkBook outside the application.
Now I am trying to use OLE control so that the excel sheet
is embedded inside my application and the queries in the
background that fetch the data from the database can be
run.

Kindly guide me on this because there is no clue
for the way that I can define the source query at runtime.

Reply me on [email protected]
or [email protected]