Hi, how do you use CopyRecordset to transfer query results from grid to Excel? It must first check if Excel exists then transfers and launches the whole Excel app. If the Excel app is already open it just transfers it to a new worksheet.

Also, a problem on grid. There are two grids one for the items called grd and the other is for its subtotal called grdSub. When grd returns a query it calculates the subtotal and it displayed on grdSub. The problem is when there is no query result the grdSub's subtotal is still there. grdSub should be blank because there was no query returned and therefore no subtotal.

Thank you in advance.

God bless,
Alvin