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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Column Width to Inches? 0
column widths keep changing in shared file 1
Column width in inches??? 3
Unable to get column width I want in Excel 2007 9
Column width of Pivot Table data goes back to default when data refreshed 2
Column widths in Excel 2013 16
Importing into Excel: column width 1
column pixels vs column width 2

Back
Top