importing text files

  • Thread starter Thread starter vaughan
  • Start date Start date
V

vaughan

I periodically import a particular text file, and each time
I go through the wizard to define column widths. Since the
widths are the same each time, is there a way to have Excel
automatically set the widths for me?

TIA
 
Can you record a macro while you are doing this and use it again.

A line like this after you open
Columns("A:G").EntireColumn.AutoFit
or
Columns("A:G").columnwidth=22
 
Vaughn,

Are you talking about the width of the columns, or the length of the fields?

What version of Excel are you using?
 
Back
Top