2
Can Excel 2007 access web services, specifically Google Finance or Yahoo Finance?
I'd like to be able to have my workbook automatically update share/fund prices from either of these sites.
I know you can import tables from websites (Import Data From Web) but this does not meet my needs. Google Spreadsheets has a GoogleLookup function to lookup prices automatically but I'd prefer to use Excel to make use of pivots, table formatting etc.
If not, does Excel 2010 have this capability?
Now voting to migrate on Stack Overflow. I thought there was a "user" answer, like I described at first, to activate simply the library. However, it seems that the only ways to do it require visual studio, or in general more programming related things, and this question will probably be better on Stack Overflow. – Gnoupi – 2010-06-30T11:22:39.720
1i think this question, as currently written, is best left here at Super User @gnoupi ... but if the answer really is "do it from Visual Studio", followup questions about specific methods or functions ought to be posted to Stack Overflow. – quack quixote – 2010-07-01T04:25:21.210
I'm going to investigate the coding route as highlighted by Gnoupi. Will post any further coding type questions on StackOverflow. – Col – 2010-07-01T08:13:37.253