Help Please... How to set the default column width in Excel for an Access export

  • Thread starter Thread starter Gary S
  • Start date Start date
G

Gary S

I am creating an Excel file via an Access export to Excel. I would
like to have the default column width increased, to eliminate the
requirement of opening the file and manually modifying the column
width. Any suggestions...???
Thanks to all who respond.
 
You could try

Private Sub Workbook_Activate()
Sheets("Sheet1").Columns("A:IV").ColumnWidth = 26.71
End Sub

in This Workbook in the VB editor so the width is changed on opening the
file. Add any other sheets required, change the 27.61 column width and the
range A:IV to your requirements,

Alan.
 
Back
Top