Get External Data - Delimiter problem?

  • Thread starter Thread starter cirmhoridge
  • Start date Start date
C

cirmhoridge

I can import data from this site :

http://sc.sc8.finance.lycos.com:443/?User=demo&Pswd=demo&DataType=DATA&Symbol=$indu&Interval=1

the data appears but not in the correct format i.e. columns are no
dividing in the right place so it may be something to do with th
delimiters (comma on the web page!) seems that the data is imported a
a table.

I just want the correct data in the correctly spaced column :)

I can import it as a text file (correct spacing) but then canno
refresh it (automatically - every minute)

I have Excel 2000

Thank yo
 
I see the problem - it all comes in as one column
I have a similar situation checking my lottery numbers from the web
I have one sheet containing the web query, and a macro button that runs a procedure that .

1. Refreshes the quer
2. Copies the stuff to a new sheet so it can be correctly delimited and formatted

This gives you a lot of flexibility...

M
 
That's right ~X, it all arrives in one column. I did however find
solution - - it is to highlight the column and go to: Data/ Text t
columns, on first menu set - delimiter, next column set, comma, nex
menu alter date format (if you wish) and finnish. Works a treat :
..............however, I have "auto-refresh" ON (1 min interval) so no
the updated data arrives in cell A1, in the ol
format................now I'm stuck again!!!!

I will try the macro thing (look in a book - the yellow dummie
one:confused: )


I enclose the file (watch it, it will change after 1 min).........a lo
of questions on this board! is this poor programming by MS or is al
software this frustrating???

T

Attachment filename: lycos.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47889
 
Back
Top