close

I have 2 linked queries to My access database.
I have 4 Worksheets in my Excel file.

I created a new MAIN worksheet. I created a button that should update
my tabs with the 2 MS Access queries.

The below code is not working?

Set wks = ActiveSheet
For Each qryTab In wks.QueryTables
qryTab.Refresh
Next qryTab

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()