Hi,

I have been given an Excel file that gets information from an Access
database using VBA code. Where will I find what the Access database is
called and what fields will it be looking at. The following code is a
snippet and I'd though that somewhere in the code I would have found out
where or what
the QueryTable refers.

ActiveSheet.Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
ActiveSheet.PivotTables("PivotTable1").RefreshTabl e

Thanks, Rob