export many qrys to excel

B

balu

dear friends.
i am looking for this
on cmdclick
(1) create an excel object
(2) work sheet . cell(1,5) value = " MY report "
(3) Worksheet.cell(2,1).value = query1
(4) worksheet.cell(2,5).value = query2
and so on
(5) worksheet .cell(2,6).value = worksheet.cell(1,1) + worksheet . cell(2,6)
(6) and i require to select the full range of cells also
and so on
how to do it please
im not so familier with excel please help me
 
Top