個案資料
了解個案內容與學習目標，選擇授課教師及使用課程。
How to Retrieve Data From Web to Excel
內容大綱
The web query feature of Microsoft Excel can be a great help in retrieving data from the web. A web query can be set up in Excel in a similar way to browsing a web page. In this note, historical stock prices are obtained from the web for use in Microsoft Excel, and a macro recorder is used to process the data and view and modify the corresponding Visual Basic for Applications (VBA) code.