I've got a query in an access database which I'm using in some vba code. I'm exporting its results to an Excel spreadsheet. All is working well except that the columns are all the same width and rather narrow. How can I cause them to automatically adjust to appropriate widths?
Here is the code:
DoCmd.OutputTo acOutputQuery, "OptCouncilRpt", acFormatXLS, "C:\Temp\OptCouncilRpt.xls"