LimitedTech
Technical User
I use the following code to export to an excel spread sheet to upload. I need the first line to be deleted on the excel sheet. It has the field names on it and the place I upload needs only the data. I have searched but am unable to find a solution.
OR
the alternate is to prevent it from being included to start with.
OR
the alternate is to prevent it from being included to start with.
Code:
Private Sub Command13_Click()
Dim strQryName As String, strXLFile As String, strName As String
DoCmd.OpenQuery "QryCheckAppend"
DoCmd.OpenQuery "QryChecksAppendBills"
strQryName = "QryDailyChecks"
strXLFile = "Z:\MyDocuments\RptChecksWritten.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, strQryName, strXLFile
FollowHyperlink "Z:\MyDocuments\RptChecksWritten.xls"
End Sub