Template keeps requiring resizing/fitting after data imported

  • Thread starter Thread starter George Lewycky
  • Start date Start date
G

George Lewycky

I have a template to re-import text files and the column headings and
column sizes keeps adjusting for some of the columns.

Is there any way to keep the settings from the template the same once
the data is imported ?

Any ideas or suggestions ?

I'm using Excel 2003

TIA


George
 
Your might record your headings and column sizes in a macro. Either create a
macro button and call the result from there or call it from worksheet
change. The latter requires no effort to update. Depending how your
worksheet is used it may give an unacceptable performance hit.
 
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

Importing data from Excel worksheet into Excel template 2
behaviour of Excel template as "read only" in a DOS script versusTemplate Icon 2
Importing PDF files into Excel 2003 1
Manipulating jpg's in Excel 2
Changing Text Import Wizard Defaults 2
Second level text does not auto resize 3
Hide column after importation data with script 3
Best Practice - Transfer Data 2

Back
Top