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
(E-Mail Removed)
<JoJo> wrote in message news:(E-Mail Removed)...
> 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" <dguille...@austin.rr.com> 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.