Unanswered: Compile Error Sub or Function Not Defined . . .
Here is the code:
Private Sub Command117_Click()
'Kill the old xls file
On Error Resume Next
On Error GoTo 0
'Export the CURRENT data
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "qryLaCustProg", "D:\flw\Access\", True
MsgBox ("Finished Exporting qryLACustProg to D:\FLW\ACCESS\")
I'm going screwy on this when comparing it to other code that works!