The posting indicated that this works. I have put the code in the Open event of the PivotTable form and it opens the PivotTable in Excel directly however I get the error "Object variable or With block variable not set" on the statment "xl.ActiveSheet.PivotTables("PivotTable1").RefreshTable".
In debug I can see that the Excel.Application statement in the set shows the same value.
I have registered (I think, I'm still pretty new to the Access coding stuff) the Excel Class library.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.