Mass Worksheet PDF Code

I have a large file around 200 sheets. Currently I use KuTools to pdf the sheets but it now crashes and I have to do a little bit at a time and cannot select the entire list.

Is it possible to write a code that would PDF all worksheets with the following naming standard 101254_Smith. The worksheets are separated by an underscore, the first set is the employee ID and the part after is the last name.


I am not sure why its crashing, perhaps its the add in but if possible I would like to try a different approach.

Take care all.

Sorry I was terrible at my description. The files have to be individual sheets with the file name being the same as the sheet name. So for example, 101254_Smith.pdf. This is very important to me since there is another job we run that takes the employee id from the file name, matches it up to their email and emails it out to them. I always save the file in a different folder since this is a monthly job and I keep the months separate in a separate folder . I hope this is a better explanation that I provided.

So not all the employee id are 6 characters, some are 3 depending what year they got hired in. The file names have to individual sheets and have to be named the same as the sheet name. So 101254_Smith.pdf as an example. Sorry if this is a big burden to change. I save these files in different folders each month, can I have the program ask me which folder to put in...or have me select it? NOt sure if this is possible, unfortunately my VBA Skills are super novice.

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

I have not tried it but is the code set up to PDF only files with th naming standard I described. Just curious. Thank you for your solution.

So I just got a chance to test the code. I am getting an error using it in my master file, the error is Run-time 5: Invalid procedure or call argument. and it is referencing this section when I click on Debug:

Please Login or Register  to view this content.

When I exported just a few of my worksheets from my mast file to a a test file, one with a 102125_Smith name and Dashboard List without the underscore. It PDFed both tabs fine, but I was hoping it would ignore the Dashboard List tab as it doesn't have an underscore and only PDF the file with the underscore.

It must not like one of the worksheets in my file. I do not have enough debugging experience to correct this unfortunately.
Thank you for your consideration.

I tried the ws.Name & ".pdf" but that created a compile error. I just kept on trying different combinations and this is what I discovered. The code stopped at hidden sheets and threw this exception when I un-hided these sheets the code worked. and it PDFed everything quite efficiently I would say.

I would like to alter this code so that it ONLY pdfs sheets with a naming standard of 101021_Smith. The first set of numbers is an employee ID separated always by an underscore and then the last name. Is it possible to change the code that it looks for numbers before the underscore, it must have an underscore and just grabs those files for PDF?
This would help me tremendously. Thank you all. At least I have taken a stab at debugging lol.


Thank you again.

First of all Mumps1 thank you for your patience with me. I am trying as best as I can to try to figure it out but its like shooting darts in the dark. It still seems to stop at hidden sheets and throws out this exceptions. Is it possible to insert a piece of code in there to ignore hidden sheets. Thank you thank you again. I am at your mercy.

That did it! Thank you. Beautiful!