Sending a query from Access to Excel

[Stefan]

I want to send a query from Access to Excel, using code,
where I can
determine to which directory and folder it shall go. I
also want to have the
possibility to name the excel-file to my own liking. Using
the button in the
tools menu sends the query to a predetermined folder and
using the name of
the query. This is no good for me. Would be very pleased
if someone has a
solution to this problem.

Stefan

 

[Stewart Tanner]

have a look at transferspreadsheet in the vba help