Problem with a macro

[kylefraney]

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

 

[Norie]

What is the problem?

Does this help?

Sub Update()
    Sheets("ParameterQuery").Range("A2").QueryTable.Refresh BackgroundQuery:=False
    Sheets("Expenses").PivotTables("PivotTable1").PivotCache.Refresh
End Sub

 

[kylefraney]

I'm getting "Run-time error '1004'
General ODBC error

 

[kylefraney]

Okay I fixed that now I'm getting a run-time error "1004"
Unable to get PivotTables property of the Worksheet class

It seems to having the error on this line

"Sheets("Expenses").PivotTables("PivotTable1").PivotCache.Refresh"

As always, any help would be appreciated.