VBA EXCEL HELP , HOW CAN I GET DATA FROM WEB

You cannot get data from a web page. A web page, when it is displayed on your browser, is dead, in the sense that it is disconnected from its server. The data on a web page is all you can see. You can, of course, copy and paste whatever data is on the page.

You can, however, get data from another web site IF that web site has opened a port and given you the credentials to have access to its server.

Requesting information from another vendor on the web is achieved by making remote procedure calls to the vendor. This is like calling a function but only in this case the function is on the vendor's remote server. The remote function returns the required information, usually in XML format. These days these remote procedure calls are called web services, which allow one server to call upon the services of another server. Of course, the other party must provide the web service and let you call his function before you can get any data from him.

What you want to do
I wante to have VBA programe get data from wed page.
- than paste to the EXCEL
- than Save a separate file

A program does not paste data to Excel, although it can be done. If you have the data, your program should CREATE an Excel file and load it with the data. Do you want to see the program paste the data to Excel in front of your face?

在 excel 的 資料 menu 下, click 取得外部資料, 再click 新増WEB查詢, 之後, 輸入要取資料的網址及要整個網頁或只要表格.
你亦可用錄製巨集的方法將上述步驟錄下, 以後就不必每次輸入所需資料了.