View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Garate John Garate is offline
external usenet poster
 
Posts: 7
Default Fix column widths in Excel template

Excel 2002, Win XP, SP-2

I'm trying to create a pre-formatted template that uses a macro to import
data from a tab delimited file. I would like to fix the column widths so
they do not change during data import. Now, when the data imports, the
column widths automatically adjust themselves to fit the data.



How can I create a template and fix the column widths so they do not change
during data import?. I know I can add the column widths to the macro it
self, but since I create many templates, this is tedious.

--
John Garate