Hi All,
You proberly have seen this before but attemptin to simply transfer a query results into a spreadsheet using
DoCmd.TransferSpreadsheet _
TransferType:=acExport, _
SpreadsheetType:=acSpreadsheetTypeExcel97, _
TableName:="query_name", _
FileName:="file", _
HasFieldNames:=True
there is...