Macros and Saved queries

Snowshoeken

Active Member
Joined
Aug 8, 2002
Messages
306
I am trying to update tables using saved queries and have them return data in the same cells where the tables reside. Idealy I would like to have a button that would run the saved queries and update the tables. Or maybe there is another way to do this by possibly using the "refresh" data function? Here is an example of the tables that I am working with.
test_example.xls
ABCDEFGH
1NPANXX
2123951123456
3123952NPANXXNPANXX
4123953123851456451
5123851123852456452
6123852123951456453
7456451123952456454
8456452123953
9456453
10456454
11
Sheet1


Regards,
Snowshoeken
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

WillR

Well-known Member
Joined
Feb 18, 2002
Messages
1,143
For refreshing an MSQuery table I use the following code.

Code:
Sub Refresh_RevGroup()
'
' Refresh Macro
' Macro to refresh MSQueries

    Application.Goto reference:="Costing_Data_Revenue_Group"
' REFERENCE REFERS TO NAMED RANGE OF QUERY OUTPUT
    Selection.QueryTable.Refresh BackgroundQuery:=False
    Columns("A:CG").EntireColumn.AutoFit
    Application.Goto reference:="Home2"

'THIS LINE JUST TAKES US BACK TO A NAMED RANGE CALLED HOME2
End Sub

HTH
 

Forum statistics

Threads
1,143,613
Messages
5,719,716
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top