export many querys to preformated worksheet

B

balu

dear
on an click event of a command button on a form
i would like to know about some code to export some selected data from many
querys to one preformated excel worksheet and do additional calculations on
that worksheet .
(a) after transfering the data how to access the said excel file from inside
the database please advise


friends,
 
Top