D
dazman
Hi,
I have a spreadsheet that grabs stock and fund data from the we
everyday using QueryTables and dynamic parameters specified in iq
files. This works well in instances when I can specify the data I wan
from a web page via variables in the URL.
I now need to be able to grab exchange rate data
http://www.oanda.com/convert/fxhistory is the place for this; howeve
its interface does not allow me to specify variables via the URL
Instead I need to post some data into the form to specify the require
days/exchange rates.
I’m familiar with the MSHTML.HTMLDocument method of having a web windo
on your worksheet which you can control and I can get the data this way
However this seems messy because I’m not so adept with the associate
event handling/timing – the Querytables seems much easier, especiall
since it’s less prone to errors.
So my question is, is there a way to use QueryTables to load a page
post the data you want, wait for the reply and get the info from th
relevant table
I have a spreadsheet that grabs stock and fund data from the we
everyday using QueryTables and dynamic parameters specified in iq
files. This works well in instances when I can specify the data I wan
from a web page via variables in the URL.
I now need to be able to grab exchange rate data
http://www.oanda.com/convert/fxhistory is the place for this; howeve
its interface does not allow me to specify variables via the URL
Instead I need to post some data into the form to specify the require
days/exchange rates.
I’m familiar with the MSHTML.HTMLDocument method of having a web windo
on your worksheet which you can control and I can get the data this way
However this seems messy because I’m not so adept with the associate
event handling/timing – the Querytables seems much easier, especiall
since it’s less prone to errors.
So my question is, is there a way to use QueryTables to load a page
post the data you want, wait for the reply and get the info from th
relevant table