Export a select query to XL Spreadsheet file

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
 
D

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?
 
S

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