Macro for Looping Through Slicer and Saving as PDF writing over same PDF

Hi All,

I am trying to loop through each option in my Slicer and save a pdf version of the dashboard which populates to show all the rep data which I then want to save to the selected file path. I should be ending up with 30 pdf's. The macro loops through just fine but it only saves one copy called NEW.pdf which it repeatedly writes over as it goes through each slicer. Here is the code I am using:

Please Login or Register  to view this content.

Any help would be greatly appreciated as I am super frantically trying to get this working for my job and this is quite over my head!

Thank you so much for the quick reply!!! I put in the code as you said and looked at the Immediate Window- you are right, they are all listed as this:
L:\XYZ\Sales Ops\K\NEW.pdf

Why is this happening and how can I resolve? The file names should be unique for each rep and save individual pdf's.

Also to my knowledge L13 is supposed to be pulling in the rep name selected from the slicer as it runs though- I have stopped the macro half way and seen that it is doing so but somehow its not saving that way, UGH!

Hi Jerry,

Do you have any thoughts on how to fix? You were right on the money with the error!

Hi Jerry,

Thank you!!! I was able to fix using the following change:

Please Login or Register  to view this content.

However I noticed the files are saving out in the K folder with NEW before each rep name in the pdf file name. It seems they aren't saving out in the New folder with just the rep name as the file name which is what populates in cell L13. Somehow its taking New as part of the file name rather than the location. Any ideas as to how to fix? Thanks in advance!!