Export to xls from ADP

[vmon]

I am struggling with exporting data in a view to an excel spreadsheet. I have tried variations and then some below. Any ideas?


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryCollectionsExport", strPath & strFile, True

DoCmd.OutputTo acOutputQuery, "qryCollectionsExport", acFormatXLS, strPath & strFile, True


thanks,
vmon