exporting a form to excel

[Andy74]

Hello,

I use the following command line to export a form (a split form) to an excel file.

DoCmd.OutputTo acOutputForm, strFormname, acFormatXLSX, strLocal

Everything fine but the column headers on the excel file show the field name but I would like them to show the datasheetview label of each control, so that the excel file will look exactly like the form in datasheet view.

Is it possible or the only solution is to write the code to open the excel file and then do the replacement automatically?

thanks