I have created a PivotTable that is going to be emailed as a word attachment. I would like to do what the “Show Pages” option does, BUT opening a word document for every page I have.
I tried to change the field with the recorder but it did not work.
So my mission is, considering I have “ALL” in the page field the code will do this:
1)Select the next item in the page field
2)Select the Pivot Range (the Table plus a few lines above it)
3)Do Copy
4)Open a new Word Document
5)Paste as Picture
6)Go back to Excel and
7)Repeat step 1
At the moment I am doing this manually (92 Times!) but I am sure you will give me a hand with this.
Thanks for your help