Check out DataGet External Data New Web Query.

NickHK

"yl358" wrote in
message ...

I have an add-on to this question.

Instead of text files on your harddrive, is there a way for Excel to
access .html files in real-time? For example, could I have a cell
always display the end-of-the-day stock quote by looking up the html
file of a financial website? I am familiar with VBA but not Excel, and
basically I am confused as to how to "transcend the gap" between .xls
files and .html files and somehow link them together.


--
yl358
------------------------------------------------------------------------
yl358's Profile:
http://www.excelforum.com/member.php...o&userid=35776
View this thread: http://www.excelforum.com/showthread...hreadid=555826