Create Excel file, format cells and export data

[n0nick]

I want to do this:

1. Create a new Excel file
2. Format cells in this new file ( fonts, color etc. )
3. Export data from a SQL query or table from MS Access.

I would like to do all this things from Access form. I got a form where user have to fill some information, and when he is finished clicks the button. Then some sql query is running and after they finished i want to export some data to this new Excel file.

Can somebody paste over some codes on how I could do this 3. things from Access VBA window.

-ismar-

 

[PHV]

And what have you tried so far ?
This is not a helpdesk. We are not here to do your job for you. Show us what you have tried already and we can try to help but we are not here to do your work for you.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886