Web Query Solution
Solution for problem posted on url:
http://excelexperts.com/automating-pulling-data-website
Please use the attached xl sheet. Change the symbol and click the button to see
| Attachment | Size |
|---|---|
| WebQuery.xls | 44.5 KB |
»
- Vishesh's blog
- Login or register to post comments
- 8959 reads
Web Query to download NAV data from Life insurance council websi
Hi,
I am a beginner in macro, and want to build a web query to b able to download company wise NAV data from the following website,
"http://www.lifeinscouncil.org/industry-information/list-of-fund-navs"
Also, I want each file to be saved in a specified folder
I'm sure this is possible via the web query option. Would really appreciate if some one could help me building the macro for the same.
Many Thanks in advance.
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