Web query (2003 SP3)

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Web query (2003 SP3)

Post by steveh »

Good morning

I have a workbook that retrieves rates of exchanges when a button is clicked and is use to convert £ to $, CHF and Euro's, it works OK but it seems that the site changes the layout of the table on occassion so I get the wrong calculation.

Does anybody know of a site whose table remains fixed to avoid this?
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin

User avatar
Leif
Administrator
Posts: 7193
Joined: 15 Jan 2010, 22:52
Location: Middle of England

Re: Web query (2003 SP3)

Post by Leif »

What source are you currently using?

I occasionally refer to the table at Barclays Business Banking and it seems not to have changed for quite a while...

I've no idea what the 'Description not found' entries are! As long as you are checking the country name, it looks like a stable table....
Leif

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Re: Web query (2003 SP3)

Post by steveh »

Cheers Leif

I will have a go with Barclays. I can't say which source I am currently using because I locked the workbook and forgot the password :grin: I am now hunting around for a last 'unlocked one' and when found will edit this post although I suspect it would have been something like XE or MSN money.
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin