有沒有可能將excel入面的資料跟internet同步?

比如我有個excel有港交所既股價,可唔可以由人手update股價變為自動update?

回答 (3)

2006-10-26 9:54 pm
✔ 最佳答案
you can use import external data function, Data, import external data, new web query, type the website address, then import. (the format is changed as excel format).

go the range of website, right click, then select data range properties, then you can select the time of refresh the data, say one minutes. so the data will be refresh automatically within a minutes.
2006-10-27 6:20 am
個excel saveas .html 咪得囉..
用一個Excel有VBA,, 開你個data excel file,, saveas .html...
未試過得唔得...
2006-10-26 8:41 pm
寫個VBA叫佢上網Cap資料落黎,理論上係得o既,不過煩囉~


收錄日期: 2021-05-03 06:13:03
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061026000051KK01049

檢視 Wayback Machine 備份