exporting data from subform
I have used this code in 2010 and 2003 to export a subform and even if the subform had filtered records, it ONLY exported the filtered data ?
Now it does not in Office 365 ?
DoCmd.DeleteObject acQuery, "qryTemp"
Set qdf = CurrentDb.CreateQueryDef("qryTemp", Me.All_ExtendedPaymentTerms_subform.Form.RecordSource)
DoCmd.OutputTo acOutputQuery, "qryTemp", acFormatXLS, "C:\Users\" & Racfid & "\Desktop\All_Extended.xls", True