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 DataText 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"
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 DataText 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"
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