Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Automatic Data Import | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |