Is there a way to set the width of Excel columns when exporting from Access?
I have VBA code to export the data to excel which works OK, but the excel file does not adjust the column to the size of the text within the fields and I have to manually adjust the columns in excel each time the data is exported.
Is there a way to do this using VBA at the time of exporting the data?
I'm using Access 2003.
Thanks in advance.