Excel VBA Macro: Save Active Sheet As PDF (Based on Cell Value)

July 31, 2023

Excel VBA Macro: Save Active Sheet As PDF (Based on Cell Value). In this video, we go over how to extract a worksheet from an excel workbook and save the data from that tab as a PDF, based on a cell to a designated file path.

Data used in this video:

#ExcelVBA #ExcelMacro…(read more)

Convert Word 2 PDF: Word to PDF Converter

Convert PowerPoint 2 PDF: PPT to PDF Converter

Convert Excel 2 PDF: Excel to PDF Converter

Convert an Image 2 PDF: Image to PDF Converter

Convert HTML 2 PDF: HTML to PDF Converter

More Tools: PDF Converter

PDF Converter

16 thoughts on “Excel VBA Macro: Save Active Sheet As PDF (Based on Cell Value)”

Hi, great totorial. Is there a way to ask VBA to ask every time where we want it saved?
If I try to print twice the same file (same name), it goes into debug error. Thanks

Thanks for the simple code. Wonderful.
1)What if I want to select a few columns,not all.
2) I want the row heading on each page.
3) I want to increase the font size and height of the rows as they are too small to read other wise.

Ты мой спаситель, я 3 дня маялся, не знал как сделать правильно

Great explanation

What if your coworker had access to the same file and wanted to run the macro from his computer. How would you add "UserName", instead of "greggowaffles" to VBA so the macro runs regardless of whether you or your coworker runs it?

Is this the same when using on mac. I have tried many times and unfortunately it throws up errors ?

could you please make one by letting the user be able to define the location of saved file by window dialog instead of writing the path?

how do i use it using a command button?

This is perfect. However my question is, what if I send the file to someone else? They should be able to save wherever they want. Can you help me with this please?

Helpful video. I was wondering if it is possible to put the path file to a certain cell so we dont have to edit through vba if we want to change the path file

Cheers from Brazil! Been trying this for hours and only your video could solve this problem!

It was a great video. I am wondering if you can save the pdf file with more settings, like A4 size, automatically reduce the size to fit in one A4 page, etc. Thank you.

Hello there, I have a tricky one I am hoping you could please help solve. I have 2 sheets, Sheet 1 has 20 names, Sheet 2 has a letter to say "____ agrees to attend this training". I am wishing to save Sheet2 as 20 multiple PDFs with 20 different PDF names according to Sheet1. ABC agreed.pdf, DEF agreed.pdf, GHI agreed.pdf and so on. I would appreciate very much if you could help!