Excel VBA – Export Each Worksheet to a Separate PDF – Macro

If you need to Export Each sheet to an individual .pdf file this Macro will do it for you.

It will go through all the sheets in your Workbook and save each one to a separate PDF file using the worksheet name as file name.


Posted by Excel Instructor:

Submit your review

Create your own review

Average rating:  
 10 reviews
by Ritesh Oza on pdfmacroexcel
Facing an issue on 6th worksheet

Hi wonderful VBcode!!

But I am getting an error of

Run-time error '1004'

Method 'Select of object'_Worksheet' failed.

First five sheets exported successfully. But at sixth sheet I am getting this error. Thanks.!

by Carin on pdfmacroexcel

It took me a few tries on the file name, but finally got it working! One more question - how do you change the code to use a cell in the file name as the tab character length is not long enough for the names I need, thanks!

by Dim on pdfmacroexcel

Thank you!

by RISHTACORNER on pdfmacroexcel

Worked like a charm . thank you so much.

by manish mungekar on pdfmacroexcel

Thank you

by Cindy on pdfmacroexcel
works like a charm!!! total timesaver

I love this macro. I use it to automate statements that I have to send out. Now I just need to figure out automating the emailing of the statements.

by Sarah on pdfmacroexcel
Excel Error

Excel had an issue with the last line before "next ws", might just be my lack of knowledge, but I was not able to use this macro. Maybe a little more instruction would help?

Most likely cause you didn't modify the path to your final folder accurately, no other changes are necessary. Many people were able to use the macro successfully as you can see from comments. Keep in mind that this macro is for Windows Excel users.

by Manoj Suryawanshi on pdfmacroexcel
Good Job

Good to see

by Abey S on pdfmacroexcel
Thank You! 🙂

Great and thanks!

by Greg on pdfmacroexcel
Thank You.

Great! Thank you so much for sharing this. I spend hours doing this every week. Now it's just a click away.