If you wanted to use the get external data - web query to download a
yahoo finance spreadsheet automatically, is there anyway to get it to
download and get it into proper column format automatically?

E.g., you want to have an automatic spreadsheet from

http://ichart.finance.yahoo.com/tabl...a=1&b=1&c=1980

so you use that as the web query, except it downloads it as comma
deliminted, NON-COLUMIZED (i.e., just 1 big column). The only way I can
figure out how to get it into columns is to manually do it, but
certainly there's got to be some way to get it to automatically sort
upon download w/o you ahving to click through to tell it to.


--
99atlantic
------------------------------------------------------------------------
99atlantic's Profile: http://www.excelforum.com/member.php...o&userid=31194
View this thread: http://www.excelforum.com/showthread...hreadid=508611

if you have it opened in excel as as you say one W I D E column highlight all
the data go to the data menu and then text to columns....somehow you can get
the same dialog before you import your data
--
paul
remove nospam for email addy!



"99atlantic" wrote:


If you wanted to use the get external data - web query to download a
yahoo finance spreadsheet automatically, is there anyway to get it to
download and get it into proper column format automatically?

E.g., you want to have an automatic spreadsheet from

http://ichart.finance.yahoo.com/tabl...a=1&b=1&c=1980

so you use that as the web query, except it downloads it as comma
deliminted, NON-COLUMIZED (i.e., just 1 big column). The only way I can
figure out how to get it into columns is to manually do it, but
certainly there's got to be some way to get it to automatically sort
upon download w/o you ahving to click through to tell it to.


--
99atlantic
------------------------------------------------------------------------
99atlantic's Profile: http://www.excelforum.com/member.php...o&userid=31194
View this thread: http://www.excelforum.com/showthread...hreadid=508611