Automating pulling data from a website
If someone wanted to automate pulling info from a website..http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?symbol=fdo and pull one line of data, populate it with the symbol in excel...then run with a different symbol and pull the same line of data, populate....how would someone do that. Doing a Web Query doesn't really accomplish what I'm trying to do. Is there a initial way to direct my research on how to figure this out? There are many stock templates that pull price data on stocks, but this data is a little different. I'd love suggestions from anyone.
| Attachment | Size |
|---|---|
| EXCEL EXPERT TEMPLATE GROK MSN-altered.xls | 191.5 KB |
Data exchance between desktop excel and embedded file on website
Hello,
I hope this thread is not dead....
Grateful if you guide me to solve the following problem:
I'm trying to automatically copy a range of cells from desktop Excel to a Skydrive Excel table embedded on a website, by pressing a button on desktop Excel. Then, during the same session, I want a range of cells from the Excel embedded table from Skydrive, to be copied on desktop Excel.
Do you think it is feasible? How?
The approach from "webquery.xls" doesn't work at all with embedded spreadsheet on the web, although in principle it could solve half of the problem...
Thanks in advance,
Gabriel