Web Query Excel VBA/ elements of a table

[bieberg]

Basic question:

Can you import elements of a table into excel using a web query or some other type of web connection without importing entire table into excel?

lets say I want to get DAY PRICE and 1 and 2

DAY PRICE EXP RATE VOL 1.0 2.0
U2 3.479 8/27/09 0.015 0.84 .49 .52

V2 3.76 9/28/09 0.015 0.84 .35 .28

X2 4.643 10/28/09 0.015 0.70 .41 .23

RESULT WOULD BE A

DAY PRICE 1.0 2.0
U2 3.479 .49 .52
V2 3.76 .84 .35
X2 4.643 .70 .23

 

[wigi]

Hi

For a recent working example, I refer you to http://www.mrexcel.com/forum/showthread.php?goto=newpost&t=411454