GBKEE

回復 3# ko310kmo

在A活頁簿的一般模組最頂端,設立公用變數.試試看

Public J As Integer
Sub 下載即時資料()
    Dim nRow As Integer
    Dim I   As Integer
    Dim X   As Integer
    Dim Y As Integer
   ' Dim J As Integer
    Dim QryTbl As QueryTable
    Dim WebAddress As String