Preserve column width formatting

  • Thread starter Thread starter fenisol3
  • Start date Start date
F

fenisol3

Hello everyone,

I have a comma separated file(.csv) linked to an excel
file so that when the excel file is opened, it refreshes
itself using the .csv file. My question is, how can I keep
each column width in the excel file constant to what I
want such that it won't be readjusted again when refresh
occurs? Thank you
 
If you're using the ActiveSheet.QueryTables.Add method one of the properties
available is AdjustColumnWidth. You'd set that to False.


--
Jim Rech
Excel MVP
| Hello everyone,
|
| I have a comma separated file(.csv) linked to an excel
| file so that when the excel file is opened, it refreshes
| itself using the .csv file. My question is, how can I keep
| each column width in the excel file constant to what I
| want such that it won't be readjusted again when refresh
| occurs? Thank you
 
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

.csv Commas ? 2
Save Excel file with certain columns with fixed width 3
Excel CSV Files; Creating Of 3
.csv Re-Format Question 1
Fixed Length, Text Formatted 2
csv format is wrong in Denmark 3
*.csv format change if .xlt save as .csv in Excel 2007 1
Column width of Pivot Table data goes back to default when data refreshed 2

Back
Top