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?
Web query (2003 SP3)
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Web query (2003 SP3)
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
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
-
- Administrator
- Posts: 7193
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Web query (2003 SP3)
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....
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
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: Web query (2003 SP3)
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 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.
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 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
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