kylefraney
Board Regular
- Joined
- Mar 21, 2003
- Messages
- 127
There seems to be problem with the below code, specifically the Refresh BackgroundQuery. Any help would be appreciated.
Sub Update()
'
' Update Macro
' Macro recorded 10/25/2006 by
'
'
Sheets("ParameterQuery").Select
Range("A2").Select
'ActiveWorkbook.RefreshAll
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("Expenses").Select
Range("B5").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub
Sub Update()
'
' Update Macro
' Macro recorded 10/25/2006 by
'
'
Sheets("ParameterQuery").Select
Range("A2").Select
'ActiveWorkbook.RefreshAll
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("Expenses").Select
Range("B5").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub