Export to Excel displaying field names instead of captions

[kattatonic1]

My users do a lot of exporting to Excel to send things off to other people, and to use as import into other apps. My field names are like strBranch. I use captions such as Home Branch, Active Branch, Original Branch to distinguish the context in the data. Export to Excel ignores the caption property whether I put it in the underlying query or the form that the user uses. Everywhere I find this question on the internet, it has been left unanswered.

Any help appreciated.

Kay from Toronto


Feels like a Monday

[ItsMe]

I base my export on a query object and use alias' in the query object.

[byrne2310]

I base my export on a query object and use alias' in the query object.

I am doing similar exports to Excel, but just starting ... Can you provide an example of the code you use? Thanks in advance!

[ItsMe]

If you do not know VBA very well you can use docmd.transferspreadsheet and base the export on a query object, creating the alias' in the query object and dedicating the query object to your export process.

Something like this.... the hardest part is getting the arguments correct for the version of Excel and path to file.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Query1", "FullPathAndFileName", True