VBA Code to Export an Access Query to Excel without the Header Row

Hello,
I am trying to export an Access query to Excel, but I would like to exclude the header row from being exported. I am using the TransferSpreadsheet command below in VBA
Any help would be greatly appreciated.

Please Login or Register  to view this content.

Most solutions call for deleting the row once you import the data

Something as simple as this maybe?

With wb.Worksheets(1)
.Rows(1).Delete
End With


if you provide a sample file with test data in it as stated in the yellow banner above, others can chime in and assist if i cant.