Ron de Bruin wrote:
When the code create the workbook you can add another sheet and create the pivot also with code
before you save the file.

Bedtime for me now but I will help tomorrow with the code

Gord look out with your code example
This will not work correct if the default save format in 2007 is not xlsx
[quoted text clipped - 17 lines]

many thanks

hi Ron,

I don't suppose you have had chance to have a look at this additional have
you?

Many thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201001/1