Excel 外部数据连结

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.

外部数据源一般是在动态数据或数据实时更新的情况（依赖于外部数据库)表格内部数据一般指数据固定或不需要及时更新；外部数据用OLE+SQL