I mean, what preliminary knowledge is needed, what concept is essential, what kind of small exe or application is involved outside the excel.

I do not have experience in this part, and no connection available either, so I did not have a chance to start in this part.

Give me your resource you have if possible, thank you very much.

No prior knowledge required. Excel is very straightforward even if slight difference for different versions is a nuisance. Typically you don’t have to worry about how applications implement DDE with Excel. Just read the software manual and find the functions they provide. If you don’t have access to Reuters or Bloomberg, you can always start with web queries. Albright updated and put StockQuery.xls at

http://www.indiana.edu/~mgtsci/home_VBA.html

[此贴子已经被作者于2007-1-10 0:51:09编辑过]

Well, still a bit confusing.

Can you give me a hint how this application is designed? I mean：

1, which part is for connection,

2, which part is for controlling data flow.

Seems it is calling the quarying function the website provides. Am I right?

Read the subroutine RunQuery. You feed the URL into the QueryTables.Add method and specify the destination cell.

I think the easiest way to learn this stuff is to record a macro, (in Excel 2007) goto Data -> From Web, type in the URL, select the fields you want, and import.

For earlier versions, I can't remember exactly, but it might be Data -> Import External Data -> New Web Query.