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.

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

columns(5).columnwidth=12

--
Don Guillett
SalesAid Software

<JoJo wrote in message ...
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" wrote...
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.