Excel Dump Of Report

[Brian Robertson]

I'm saving the output of a Report to Excel but the order of the columns bears no relation to the report or the query behind the report. How do I set the order of the columns ?

 

[Pat Hartman]

It would probably be easier to just export the query.

 

[Brian Robertson]

I've used the DoCmd.TransferSpreadsheet function in VB to create the Excel document in the correct column order based on the Query. Thanks for your help.