Web Query Solution

Vishesh's picture

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

AttachmentSize
WebQuery.xls44.5 KB

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