Options when opening a CSV file

  • Thread starter Thread starter wmcafee
  • Start date Start date
W

wmcafee

I am creating a Comma Separated File (.csv) from a commercial reportin
package (Actuate). When I click on the resulting .csv file, MS Exce
opens and the file is read fine, but every column is defaulted to
common and narrow width of 8.43.

Does anyone know a way to have MS Excel open a .csv file or an .xl
file for the first time and have the widths expanded automatically t
"Best Possible Fit"?

Thanks,
We
 
And if you decide to use a macro approach, you may want to rename your .csv file
to .txt.

Then you could record a macro when you open that .txt file. Do all the
formatting, print layout, headers, filters, subtotals-whatever else you need.

Then whenever you need to do it again, just run that macro.
 
Back
Top