software

If you wanted to use the get external data -gt; 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

ichart.finance.yahoo.com/tabl...a=1amp;b=1amp;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: www.excelforum.com/member.php...oamp;userid=31194
View this thread: www.excelforum.com/showthread...hreadid=508611if 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!
quot;99atlanticquot; wrote:

gt;
gt; If you wanted to use the get external data -gt; web query to download a
gt; yahoo finance spreadsheet automatically, is there anyway to get it to
gt; download and get it into proper column format automatically?
gt;
gt; E.g., you want to have an automatic spreadsheet from
gt;
gt; ichart.finance.yahoo.com/tabl...a=1amp;b=1amp;c=1980
gt;
gt; so you use that as the web query, except it downloads it as comma
gt; deliminted, NON-COLUMIZED (i.e., just 1 big column). The only way I can
gt; figure out how to get it into columns is to manually do it, but
gt; certainly there's got to be some way to get it to automatically sort
gt; upon download w/o you ahving to click through to tell it to.
gt;
gt;
gt; --
gt; 99atlantic
gt; ------------------------------------------------------------------------
gt; 99atlantic's Profile: www.excelforum.com/member.php...oamp;userid=31194
gt; View this thread: www.excelforum.com/showthread...hreadid=508611
gt;
gt;