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

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.
 
A

Alan

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.
 
Top