Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error in Creating EXCEL Pivot Table using ACCESS DataBase
Thanks for the reply. It stops at following step: ' Create pivot table Set PT = PTCache.CreatePivotTable( _ TableDestination:=Sheets("PivotSheet").Range("A1"), _ TableName:="BudgetPivot")- vivek1431
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error in Creating EXCEL Pivot Table using ACCESS DataBase
Hello: I am trying to create a pivot table in EXCEL using an ACCESS Database. However, I am getting an error which says -Runtime Error 1004 : [Microsoft][ODBC Microsoft ACCESS Driver] Could not find the file 'unknown'. This is a VBA code straight from John Walkenbach's book. It wuns when I run...- vivek1431
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
