Can you use QueryTables & iqy file to post web data?
 

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

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=39568