Macros and Saved queries

[Snowshoeken]

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
	A	B	C	D	E	F	G	H
1	NPA	NXX
2	123	951		123			456
3	123	952		NPA	NXX		NPA	NXX
4	123	953		123	851		456	451
5	123	851		123	852		456	452
6	123	852		123	951		456	453
7	456	451		123	952		456	454
8	456	452		123	953
9	456	453
10	456	454
11
Sheet1

Regards,
Snowshoeken

 

[WillR]

For refreshing an MSQuery table I use the following 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