Connecting to a Websites Information

[e4excel]

Dear Forum,

I need help in getting connected to a site where all the Interest Rates are mentioned in Excel..

http://www.maduraidirectory.com/bandf/interest.php

There are around 6 tables in Excel shoiwng different Interest rates for different banks for diffferent time periods ...

I need to get connected to this site to save time in extracting the files each time there's a change..

Is this possible?

[Leith Ross]

Hello e4excel,

How you tried using a web query to retrieve the data?

[e4excel]

I am not able to follow that as I have Excel 2007, if thats the solution can u please explain the same or maybe something better...

I want to have this data connected as this would be the basis of my file...

[e4excel]

Dear Leith Ross,

I tried researching on Web Query but I have not been able to follow it completely, so would appreciate if you could explain the same and also I need to know in case I need to add more websites as there would be some Scheduled Banks not mentioned in t he earlier site..

SO please explain the procedure if possible..

Regards
e4excel

[Leith Ross]

Hello e4excel,

To best answer your question click here to see how to do this step by step.

[e4excel]

Thanks a lot Leith Ross,

That was very useful, however I never get the below Step.

I directly get the "Coneecting Live Data" and Cell to be stored In..


I dont get the LAst Step "Enter Paramewter Values" ?????

The fun thing is, that you can either fill in a value or you can select a cell as an input for the parameter:

By checking the two checkboxes shown above, you ensure that Excel will automatically update the query table when you change the content of the cell(s) you selected.


So pleae explain the same.

Thanks