Altered Column Width

[Guest]

Folks:


In use one column of my spreadsheet to import a text file. Each day I run a
refresh on the data.
However, after refreshing this data, I notice that the width of the column
into which data is received gets altered.

* How can I prevent the width of the single column from being changed as
I import data from a text file ?



Thanks,
John.

 

[Don Guillett]

Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12

 

[Harlan Grove]

Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12

....

Or store the column width in a variable first, import into the column,
then restore the saved column width.