Create Excel pivot chart from within Access

[projecttoday]

I am looking for working code or a working example of an Excel pivot table creation from an Access database. If you have ever successfully created a pivot table in an Excel spreadsheet using VBA code in Access, please post the code or a database with working code. I need to insert an Excel pivot table onto an Excel spreadsheet. I want to do this running code in Access. If you can do this, please post.