Export a select query to XL Spreadsheet file

[Skip Bisconer]

Can some one explain to me why this code does not do the subject matter?
Thanks for any help you can give me.

Private Sub Command2_Click()

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Skip-Customer
Monitor By Quarters", _
"C:\Mydocuments\Ben's Business\TestExport24MonthHistory.xls"
End Sub

 

[Douglas J. Steele]

So what does it do? Do you get an error message? If so, what's the error? If
there's no error, what's happening, and how does that differ from what you
want?

 

[Skip Bisconer]

Thanks for responding Douglas. In finding an answer to your questions I found
I had an incorrect path statement for the destination file. I appreciate your
help.