Pulling a value from the internet

[mattmexcel]

Hi all,

I'm writing a macro, and I want it to pull the 30-year current yield for municipal bonds from the website: http://www.bloomberg.com/markets/rates/index.html

Any clues on how I would go about doing this? I'm lost.

Thanks,

Matt

 

[Norie]

Is this the data you want?

<TABLE cellSpacing=2 cellPadding=2 width="100%" border=0><TBODY><TR bgColor=#ffffff><TD align=left>30-Year</TD><TD align=right>5.06%</TD><TD align=right>5.02%</TD><TD align=right>0.02%</TD><TD align=right>7.03%</TD><TD align=right>4.87%</TD><TD align=right>4.70%</TD><TD align=right>4.69%</TD></TR></TBODY></TABLE>

 

[hkaplan2]

record:

Data | Get External Data | New Web Query

Depending on which version of Excel. That is where you enter websites and select tables to be updated. Try it before you record the macro. Pretty easy with XL 2003 and up.

 

[mattmexcel]

Yep, those were the values I was looking for. Thanks HKaplan2 for the easy record recommendation. Don't know why I didn't think of that one.

-Matt