Export a select query to XL Spreadsheet file

  • Thread starter Thread starter Skip Bisconer
  • Start date Start date
S

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
 
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?
 
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.
 
Back
Top