Export MS Access query to MS Excel

[Agarfey]

Hi People,

I currently use the following code to export a MS Access query into MS Word. I would like to know how to achieve the same result. ie Export to Excel in place of Word. Can anyone help.

Private Sub cmdExportWord_Click()
Dim strQueryName As String
strQueryName = "qdf_Export_DA_Objectives"
Call qw_wExportRTF(strQueryName)
End Sub

Thanks
Abe
This message was edited by Agarfey on 2002-09-09 15:25

 

[Juan Pablo González]

This Sub is what handles the exporting, not the one you posted.

qw_wExportRTF

so, without looking at it, it's very difficult.

 

[DonkeyOte]

It seems a lot of people encounter problems importing/exporting to Access through VB!

Are you wanting to run the procedure from within Access or Excel?

My recommendation would be to set up the macro in Access if you're more comfortable in Access than Excel(DoCmd etc...) and then write a simple Macro in Excel that calls the Access procedure.

 

[gareth]

Why use VBA when you can simply save it as an .xls file in Excel from Access ???