Search results

I'm using DoCmd.TransferSpreadsheet acExport to send data from a form to Excel and would like to be able to format the resulting spreadsheet, eg autofit columns, centre columns etc directly from Access. This code does the basic job of creating a destination subfolder in the folder containing...