Using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_SoilB", "F:\WH\Ft\Soil Report\qry_SoilB.xls", True, "Test1"
I get Runtime Error '3011' " Microsoft Access database engine could not find the object qry_SoilB. Make sure the object exists and that you spell its name and...