web query

zulychg

Board Regular
Joined
Nov 19, 2005
Messages
60
Can someone give me some hints how to use web query in excel? i tried many times to download currencies rate from oanda.com website. However, once i select the part that i wants the only date imported is some words, but not the rate. another concern is how can i download various fx rate at the same time to a same worksheet? is throught a macro?

thanks
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top