VBA query - Excel export

[Fostertrident]

Hi



I'm using the following code to export an access query to excel:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Ready for letter", "C:\Users\XXXXX\Readyforlettersend.xlsx"

, True

Is there any way of adding some code to ensure that when the query is exported to excel it's exported as a table.

I tried recording a macro to see how excel makes a Table but i can't seem to integrate it into my VBA code in access.

ListObjects.Add(xlSrcRange, Range("$A$1:$Q$3"), , xlYes).Name = _            "Table1"
        Range("Table1[#All]").Select

Many thanks in advance.

Kind regards

[ranman256]

your export is correct, but you'd need to use vba to open the file after export, then build your table.

[Welshgasman]

Why not send the letter data straight from Access?