Use Max value of a pivot (page) field

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Use Max value of a pivot (page) field

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 15th, 2007, 07:06 AM

paul20091968 paul20091968 is offline

Authorized User

Join Date: Apr 2006

Posts: 53

Thanks: 0

Thanked 0 Times in 0 Posts

Use Max value of a pivot (page) field

Hi everyone,

I have a pivot table with a pivot page field called "Month". I would like to save this report and want to use the variable (MAX) of the month. for example if I run a report for the month of December 2006, then the file is saved with this in the file name.

How can I "capture" the Max value in pivotfield "Month" as a variable.

Best regards,

Paul.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to set hidden field value AFTER page reloads	savoym	Javascript How-To	5	June 13th, 2007 10:13 AM
Parameter field in Olap Report with Page dimension	dma	Crystal Reports	0	June 3rd, 2004 06:01 PM
how to added a calculated field in pivot table	ndenhere	BOOK: Access 2003 VBA Programmer's Reference	0	May 27th, 2004 02:45 AM
making a db field link on a page	doranaz	Classic ASP Databases	0	December 19th, 2003 01:13 PM
add an autonumber form field on web page	seogreenie	Javascript How-To	1	December 13th, 2003 11:52 PM