影。像。生。活: Excel運用VBA抓取Yahoo Finance APIs股票資料

'宣告變數 Dim QuerySheet As Worksheet Dim DataSheet As Worksheet Dim qurl As String Dim i As Integer '告訴Excel不要每更新一格就重新計算 Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation ...

kuanming-style.blogspot.com