Help with formatting column widths in vba upon export to excel from access.
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?