Specifying Column Width in Excel after using the TransferSpreadsheet Command in Access
Posted on 2003-10-23
I am using the DoCmd.Transfer Spreadsheet function in Access to output queries to Excel. Is there a way to specify the column width in Excel from Access? The problem is that I am using a new spreadsheet each time and so I can't just format the spreadsheet. I need Access to pass the column width info to Excel. Below is the command that I am using in a Module in Access. Thanks for your help.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strSourceName, strFileName, True