Hale, Jim
Jim.Hale at FleetPride.com
Tue Jun 8 13:01:19 CDT 2004
These should get you going although frankly none of them cover my favorite method which is to create an excel template with the pivot table formatted and then read data into a hidden sheet whenever I want to update the table. HTH Jim Hale Excel 2000 power programming with VBA - Chapter 16 John Walkenbach Excel VBA professional project - chapter 14 duane birnbaum Writing Excel macros - chapter 20 Steven Roman Using Excel Visual Basic for applications 2nd edition - chapter 12 Jeff Webb -----Original Message----- From: JOHNWARDBELL at aol.com [mailto:JOHNWARDBELL at aol.com] Sent: Thursday, January 15, 2004 5:20 AM To: accessD at databaseadvisors.com Subject: [AccessD] Pivot Tables Book I am looking for a book on programming Pivot tables using vba. Has anyone got a recommendation? using A2k or later. TIA johnb _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com