Looping through Slicer and Saving to PDF - Error

**kmunoz** · 03-26-2021, 04:56 PM

Hi There!

I am having an error trying to save to PDF as the code cycles through the Slicer. I borrowed this code from a 4 year old thread on the site: 1184223-macro-for-looping-through-slicer-and-saving-as-pdf-writing-over-same-pdf.html - sorry I can't post a link yet!

But it continues to break at the PDF section. When I remove it, I can see that it is cycling through the slicer. I am not super well versed in VBA's, but have successfully used VBA's that cycle through dropdown menus and save to PDF. I am getting run-time error code 5 - invalid procedure call or argument

Any help would be appreciated! Thank you in advance!

Also I am referencing cell D1 - as a cell that is referencing the Pivot Table's cell from another sheet - please let me know if that is wrong

Please Login or Register  to view this content.

**dangelor** · 04-02-2021, 11:27 AM

Possibly...

Please Login or Register  to view this content.

**kmunoz** · 04-06-2021, 12:12 AM

Awesome!! Thank you SO much this worked!! I did get an error when I initially copied it in with the sPath, so I removed it from the code. It did start saving the PDFs into a folder I had open. What can I change so that it requires the user to choose the folder?

I truly appreciate your help!

**dangelor** · 04-06-2021, 07:05 AM

Try replacing this:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

**kmunoz** · 04-09-2021, 03:45 PM

Thank you SO much! That fixed it. I did figure out that I did have to change the filename at the bottom to include the "\" as well - but it worked great! I really appreciate your assistance.

I did have one more question - I am so sorry!
If I want to change the Sheet name from "Sheet2" --> "Teacher" I am finding that the macro breaks - what might I be doing wrong?
I also am wondering if the part that says "Sheet4" down towards the bottom (Sheet4.ExportAsFixedFormat - is that something that can't be changed or needs to also update to something different if I change the sheet name

Please Login or Register  to view this content.

**dangelor** · 04-09-2021, 04:49 PM

The way the code is written, Sheet2 is a code name for a worksheet in the workbook containing the code. If Teacher isn't a code name of a worksheet in the workbook holding the code, it will fail.

Try replacing Sheet2 with ActiveWorkbook.Worksheets("Teacher").

Use a similar procedure for the code name Sheet4.

If you still have problems, follow the directions in the yellow banner at the top of the thread to post your workbook.

Looping through Slicer and Saving to PDF - Error

LinkBack

Thread Tools

Rate This Thread

Display

Looping through Slicer and Saving to PDF - Error

Re: Looping through Slicer and Saving to PDF - Error

Re: Looping through Slicer and Saving to PDF - Error

Re: Looping through Slicer and Saving to PDF - Error

Re: Looping through Slicer and Saving to PDF - Error

Re: Looping through Slicer and Saving to PDF - Error

Thread Information

Users Browsing this Thread

Similar Threads

Loop through slicer, while also selecting single slicer value on separate slicer

Duplicate slicer selection onto other slicer (master/slave slicer)- super slow performance

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

looping through folders - saving xls files as PDFs

looping through folders - saving xls files as PDFs

Importing, looping and saving (not really solved)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions