data import and text to columns

S

sswave4dave

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/latest_run/enp.46062.bull

Thank you,
David
 
G

Gord Dibben

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
 
S

sswave4dave

perfect, thanks!
-David


Gord Dibben said:
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
Click to expand...
 
Top