data import and text to columns

I am trying to import a table, separated by delimiters, from the web. The
table's data changes frequently. I can use text-to-columns to sort the table
into the proper columns, but don't want to have to do this every time I
refresh the data. Is there any way around this? Heres the table I'm talking
about.

http://polar.ncep.noaa.gov/waves/lat...enp.46062.bull

Thank you,
David

David

Try turning on the macro recorder while you open the web site, select all and
copy then paste to an Excal sheet and do your Data>Text to Columns as pipe
de-limited.

Run that macro when you want to reset the data.


Gord Dibben Excel MVP

On Wed, 4 May 2005 22:15:18 -0700, "sswave4dave"
<[email protected]> wrote:

>I am trying to import a table, separated by delimiters, from the web. The
>table's data changes frequently. I can use text-to-columns to sort the table
>into the proper columns, but don't want to have to do this every time I
>refresh the data. Is there any way around this? Heres the table I'm talking
>about.
>
>http://polar.ncep.noaa.gov/waves/lat...enp.46062.bull
>
>Thank you,
>David

perfect, thanks!
-David


"Gord Dibben" wrote:

> David
>
> Try turning on the macro recorder while you open the web site, select all and
> copy then paste to an Excal sheet and do your Data>Text to Columns as pipe
> de-limited.
>
> Run that macro when you want to reset the data.
>
>
> Gord Dibben Excel MVP
>
> On Wed, 4 May 2005 22:15:18 -0700, "sswave4dave"
> <[email protected]> wrote:
>
> >I am trying to import a table, separated by delimiters, from the web. The
> >table's data changes frequently. I can use text-to-columns to sort the table
> >into the proper columns, but don't want to have to do this every time I
> >refresh the data. Is there any way around this? Heres the table I'm talking
> >about.
> >
> >http://polar.ncep.noaa.gov/waves/lat...enp.46062.bull
> >
> >Thank you,
> >David
>
>