Create PDF from an Excel sheet using a Single Click (Macro for Generating PDFs from Excel sheets)

This video is about converting an Excel sheet into a PDF using a single click. Step by step method to create a macro for generating PDFs from Excel sheets is explained in this video.
Subscribe to the channel for more
/ ajayanandxlncad
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
#ExcelToPDF #ExcelMacro #exceltip

[@AjayAnandXLnCAD]

Macros explained vidoes of XL n CAD can be downloaded from the following link xlncad.com/macros-excel/

[@m.ssharma535]

Exactly what I was looking for. Create a dashboard in excel and send that PDF.

[@deniseoliver6567]

Thank for for not holding your knowledge hostage! Your expertise is much appreciated. Thank you.

[@JimmyHutchison-b4g]

I use the Publish to PDF command after adding the command into the home ribbon in its own group. Works great too!

[@commandermcnash5137]

Thanks, you have reduced my job per item from 45 seconds to 5 seconds, I had to make 348 pdfs so you can imagine how much time you have saved me.

[@AjayAnandXLnCAD]

Glad to hear that :)

[@helenshanmugam1963]

Thank you very much Ajay. Your step by step guide helped me to accomplish what I wanted to create.

[@AjayAnandXLnCAD]

You are most welcome

[@shanjose1583]

Thank you for the tutorial. Much appreciated. I do have a question. Will it download the file as PDF in the Download folder if the Filename is not mentioned?

[@ossiangranit4891]

Hi, thanks for this, its exactly what I need, however, I'm getting a "error while printing message" --> Run-error '1004' Application-defined or object-defined error. I think its because I am on a mac and the filename i'm using isnt correct. How do I write this code so it works on a mac? Thanks in advance!

[@Liam-fb4tu]

This is a great video Ajay! Thanks very much. Can I ask how could I get this to run automatically when the spreadsheet is opened rather than having to click a button? I have a spreadsheet that’s exported from an application that I want to convert straight to pdf

[@ajmersinghjadoun2367]

Very Nice Video. Done we can make PDF of all Paysilp on one click.

[@Ajaggi81]

Very useful video. Is there a way to print them all together rather than one by one

[@sharrongay1708]

Thank you so much. This video has solved an issue I have been struggling with for quite awhile.

[@AjayAnandXLnCAD]

My pleasure 😀

[@TariqJahangeer]

Thanks for your tutorial sir,could you please explain me we are making different different Clint PO/QUOTATION with each Clint have each folder name how to give file path in VBA code ? is there is any another option to save pdf file as multiple path ......Thanks

[@adhowie]

great video an easy method ,is it possible to use two separate cells as the saved file name?

[@dikky3349]

can it to be automatic?, because i have 454 data to convert into PDF. and thank you very much it really helpfully me to reduce time work.

[@balance1772]

Thank you so much, brother.!!! Could you please make one more video on creating multiple Excel files to PDF at once?

[@AjayAnandXLnCAD]

My pleasure 😀

[@janijohn5945]

Hi, Thnks For the video. I need a small change here, for full workbook print i can use ActiveWorkbook, what if i have to ignore the first page and save all other pages as single pdf

[@HandsomeHunk1618]

Hello Ajay ji..... One query. Pls address. How to generate pdf for each unique user in a filter in whole data of Excel?

[@darxcyber]

great video, really informative. i have a question though, can you do this with multiple worksheets in a work book and assign to one pdf function?

[@umairatulafiqah6534]

Thank you soo much Ajay for this video. Really helped me? Is it possible if it automatically creates a new file name and the pdf file is saved there?

[@AjayAnandXLnCAD]

can you please explain it with an example?

[@patpat5296]

Nice job Ajay! When clicking the button, would it be possible instead to send the PDF via email to a customer's email (already written on the excel sheet)?

[@AjayAnandXLnCAD]

Yes. but it's one of our different products for sale. Check the videos of XL n CAD Products for more details.

[@patpat5296]

@@AjayAnandXLnCAD I dont understand. Can you show me a link where I can buy the macro? My goal is to push a button on a worksheet and it automatically converts to a PDF and then email to a customer's email already written on a cell in that worksheet.

[@shahzadisrani2616]

Sir it is great to see your video, we can make pdf by save as type but my query is if i have 5 sheets & want to save 3 sheets in pdf by 1 click so is it possible?

[@juliaalonzo7489]

Thanks! Very helpful video. May I ask if I can also save this in Sharepoint or other cloud based storage so that the generated PDFs will be saved in that location?

[@AjayAnandXLnCAD]

I haven't tried that yet. But this is an interesting suggestion. Will let you know once I develop a solution for this.

[@mariamokoena7448]

Has anyone tried using the macro and saving in SharePoint?

[@gillesdevriendt9575]

Hello, Thank you for this amazin upload! Would it be possible to let some nothification pop u when you try to save it twice? Thank in advance!

[@premnathkrishnan320]

Awesome sharing, saved tons of time for me for saving report.

[@shibubaby6209]

Thanks sir for vba tutorial, Is there is possible to create non editable pdf this same way

[@AjayAnandXLnCAD]

You are welcome. It should be possible with a third party software, but I haven't tried it yet.

[@jaythumar1201]

Thanks a lot, its really Good Informative .....

[@mahirbadanagki]

can the user choose the file where the pdf would be saved manually using window dialog instead of writing the path?

[@MustafaAhmed-mb7hu]

Excellent work there......how does the program determine the printable area.....since there was no reference to the same in your vba coding

[@AjayAnandXLnCAD]

You should set the print area. I already had it.

[@Someone-xg1ff]

@@AjayAnandXLnCAD How do I do that?

[@davidhermosilla6942]

Hello, can you please explain how did you have saved only the table and not other information in the spreadsheet?

[@karuppusamyn515]

Thanks you sir... How to create pdf Same method from selected multiple ID number in single pdf documents like ID number selection

[@autobahnmensch]

excellent, exactly what I needed, worked the first time, thank you

[@chiranjeebdhar4941]

Thank you Sir. Very nice video. If I want to select a range in my excel template and convert to pdf- if you please guide on this what will be the vba code

[@chiranjeebdhar4941]

If you please advise on the above query?

[@AjayAnandXLnCAD]

You can define the print area using a statement like the following Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"

[@chiranjeebdhar4941]

Thanks Sir. If you please advise where in the code I will insert this line in the module.

[@sbxcel]

It's great! How can I set the file location if this file is sent to other PCs? Thanks

[@sweetjeba1981]

Very Very Useful for me... Thanks a lot

[@jeromgerald]

Very useful video tutorial ... 👍 and thanks for the download link...

[@AjayAnandXLnCAD]

Happy that you find it useful. and thanks for leaving a feedback :)

[@mohanvaze1]

Excellent narration. Very easy to follow. Thank you Ajay

[@udayhyd9150]

very good video, very useful

[@AjayAnandXLnCAD]

Glad you think so!

[@motivation_AI_success]

Nice and helpful video. Is there is possible to create all employees payslip in one click button.

[@AjayAnandXLnCAD]

Yes

[@ahmedabdulmonem7665]

great work sir I have a question, how can I create the pdf in landscape mode

[@AjayAnandXLnCAD]

You have to set the Print area before executing the Macro

[@goldilocks1964]

Excellent explainer video, Jay! Thank you a lot! Oh, how would I add today's date and time to the file name during the save process?

[@AjayAnandXLnCAD]

Thank you. For time stamps in file names, refer the following blog post. www.extendoffice.com/documents/excel/4413-excel-timestamp-filename.html

[@smisinu]

Thank you so much for the video

[@AjayAnandXLnCAD]

You are so welcome!

[@aaronyap4515]

My exported PDF was pagebreak into other pages because of hidden columns and rows, for example hidden column B-E, hence column A one page, column F another page, is there any code that can fix this?

[@mohammedjunaidhussain7691]

@ajay anand br how to write code for ID which i need from two or three cells ?

[@amolpathakndb]

excellent video sir

[@AjayAnandXLnCAD]

Thank you :)

[@havelotz]

Can you make this type of video for google sheets pls

[@sugiartosugiarto5306]

how if we need to print chart also, how we write the skrip bro?? thanks

[@nicolegrater]

This is very helpful! Thank you! Is there a way to automate this for a group of statements? I have 100+ single statements to save that need to be converted to pdf. Instead of selecting each one and then converting, is there a way they can all be created automatically?

[@AjayAnandXLnCAD]

You need to place the statements inside a 'For' loop. I suggest to watch my video on this topic for a better picture.

[@yasmeenhameed2148]

@@AjayAnandXLnCAD please can you send the link of your video that explaining this topic Thanks

[@mohdrazlanjaafar7678]

@@AjayAnandXLnCAD ya. I still cannot find the loop for run the dropdown list

[@cpusamath]

@@AjayAnandXLnCAD Link Please

[@jnmendoza1047]

link for loop pls..

[@psaha7584]

Thank u so much sir

[@ahmedhelal920]

thanks , what about if i have 5 excel files and i need to convert all of them to PDF ? how can i do this with macro ?

[@cobra777888]

Thankyou so much Ajay, this macro saves my time.

[@AjayAnandXLnCAD]

Glad to hear that

[@sneekc2146]

You’re amazing! Thank you

[@AjayAnandXLnCAD]

You're so welcome!

[@imankassim95]

how do i create the table in payslip using the employee details. wht is the key word to learn

[@shivakumar-in8mc]

Thank you so much

[@anubhesh]

I made a pdf. If the file is open and press the print button Will this command over write it ❓️like wise how to combine all the PDF. Code for that also

[@ShivaKiranT]

What happens if the file name already exists in the folder? Will it asks to replace the old file with the new or it just gives error?

[@linggeshwaraan2663]

Thank you so much :). This really helps me.

[@billydamanik4784]

Hi Ajay, How to use loop function if I want to create PDF for all payroll automatically. Thanks

[@AjayAnandXLnCAD]

Hi Billy, please watch my video on Loops in VBA.

[@billydamanik4784]

@@AjayAnandXLnCAD would you mind telling me which video you mention. I am new to macro. So please help me :)

[@indianhiddengems7137]

What if I need to multiple tab so do I need use the same formula again'

[@jignesh318]

Google work sheet mai same setting possible hai??

[@vinodkumar-uo5lx]

Sir is it workable in Office2007 or not.? Kindly suggest

[@AjayAnandXLnCAD]

Yes. It will work with Excel 2007

[@mihalio3739]

Ajay, when i click on my print button, it generates 4 pages of pdf, my range is from A1:K52 so not that big, how can I compact this to just one the page? Thank you

[@XLnCADMalayalam]

Michael, use the Page Layout tab to redefine your print area. This particular macro prints whatever is there in the print area.

[@johandaugaarddrejer9009]

Very useful, well done!

[@khajashamshuddin3655]

Very helpful. thank you

[@AjayAnandXLnCAD]

My Pleasure

[@tomastotori5600]

Sir I have cells from a to g so how to make so that all the cells are Included in the pdf. In the coding part you wrote d cell but I have more cells how to make.sir also help me in adjusting the alignment

[@AjayAnandXLnCAD]

Maybe I will write on this topic in my blog.

[@darshankhire5855]

Thanks bro

[@أخصائيمشتريات]

Sir ajay Type:=xlTypepdf, _ Showing expected identifier.... Erorr Pls help me how can I solve it

[@AjayAnandXLnCAD]

Identifier Error means you have used the reserved words as the name of consts or variables.

[@أخصائيمشتريات]

It is work... Thanks a lot with highly appreciated.

[@tegalinks01]

I want to do a similar thing for a list of about 400 employees but I am having issues with the deduction aspect because not all employees have the same number of deductions. Some are more than others. I need help please

[@harshaldeshmukh9870]

Can we convert the Excel table to word file with additional data at specific para. Please guide Thanks in anticipation

[@AjayAnandXLnCAD]

Can you please explain the issue with an example?

[@Omshanthiom9]

Hi Ajay, nice video and really helpful. can you please show how to create pdf in a landscape format. Thanks

[@sankarmondal89]

Thanks. But I have 5 sheets in a single file. I want to save all the sheets in a single PDF. Can you tell me how?

[@QadeerAhmed-qf1st]

Super

[@bijaytanty8434]

Good

[@haveagoharry4999]

Class, thanks very much for this :)

[@AjayAnandXLnCAD]

My pleasure :)

[@diegofinal77]

Muchas gracias! Muy útil.

[@centuriongamers2674]

Sir can you help to to same in google sheets

[@cajitendrarithadia4544]

Hi, I want to save entire excel file in PDF format with file name as mentioned in excel and in the same folder in which excel file is stored. I have written VBA Code. Sub CreatePDF() ThisWorkbook.ExportAsFixedFormat xlTypePDF, openafterpublish:=True End Sub This VBA Code saves filed in documents folder of my PC but i want to save in the same folder in which excel file is located. Can you help in with VBA Code.

[@zigapodlesnik5106]

when i click button it writes to me aplication-defined or object-defined error.... what could it be?

[@CikguFzan]

Tq! very useful

[@AjayAnandXLnCAD]

So nice of you

[@gauravKumar-cj5hu]

Pls confirm How Can we get pop up to save pdf file

[@SwetaJindal-db7ed]

hi ... Can you help.. I got stuck with code for PDF generation.

[@kshitijshinde4192]

Hi..sir can we give filename i.e to save pdf in network path

[@coolraghumiskin09]

SIR I AM FEELING VERY HAPPY FOR YOUR SUPPORT , I AM FINDING DIFFICULTY IN CREATING A PDF THERE IS A ERROR >>>>> RUN TIME ERROR 5

[@AjayAnandXLnCAD]

I tested the program before sending it to you and it was working properly. I would like to remind that there should be a folder called Raghav In your E: Drive

[@coolraghumiskin09]

@@AjayAnandXLnCAD Sir, I Have firstly created the folder and then executed the VBA, But it is not working properly.

[@meganspelman1660]

Thank you for you video, I keep getting 1004 error. Can you please have a look at my code to see if you see anything that would cause this? ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:="Users atahn\Documents\Spelman Enterprises\AGFB ERIC\" + ID + ".pdf", _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False Thank you for any assistance.

[@AjayAnandXLnCAD]

Try the following code Sub CreatePdf() Dim ID As String ID = Range("D4").Text ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:="E:\Payslip\" + ID + ".pdf", _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False End Sub

[@MrLunesh]

Sir plz solve my problem its not working i have written in same way...

[@HarryUnchained]

Is there any way to automatically generate PDF for all IDs in the drop down list with 1 click?

[@marcelwolters8315]

exactly my question too

[@MdAshrafulIslamMilon]

Sub CreatePdf() (Showing Yellow Color) not working , can u help me ?

[@brianwilliams5152]

Hi Ajay I have Excel 2019 Win10, didn't work for me

[@mohammedomran5458]

Couldn't subscribe in order to download the ready macros.. would you share it? Thanks

[@AjayAnandXLnCAD]

Visit xlncad.com/macros-excel/

[@mohammedomran5458]

Ajay Anand Thank you for your response

[@agk1109]

I had download 51 VBA codes pdf it is wonderful .but my excel code to covert to pdf is not working.

[@sainadh154]

How to create pdfs for all the employees in the drop down list automatically with one single click ? Please guide me.

[@SatishRai1310]

hi i followed the code but i am getting a syntax error please help

[@ramzein776]

does it save twice if I click x 2 ?

[@AjayAnandXLnCAD]

The file will get replaced.

[@ramzein776]

@@AjayAnandXLnCAD Thanks sir Sub CreatePdf() Dim ID As String ID = Range("H19").Text ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:="Data:\Payslip\" + ID + ".pdf", _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False file Path/ Volumes/Macintosh HD - Data This what I did and using a Mac , it doesn't work kindly advise

[@sufalhalder1734]

Run Time Error '5' Invalid procedure call or argument. how to fix that?

[@prashanthkumarj7301]

How to generate all data of different id in a single PDF file instead of creating separately

[@tomastotori5600]

Hi sir, it says can't run the macro book 1button the macro may not be in this workbook or so macros are disabled

[@AjayAnandXLnCAD]

If the Macros are disabled, you can enable them by following the steps given below. Got to File tab > Options > Trust Center > Trust Center Settings > Macro Settings > Select Enable all macros > Click OK

[@tomastotori5600]

@@AjayAnandXLnCAD tq sir.

[@pawandeep7940]

How can we save and open the file in pdf by one click??

[@jasmeetsinghsaluja7390]

Sir i want to save my file with invoice and customer name.. both are in different cell ... how can i do it.

[@tutsecret499]

Try this, test it out, like an improvisation: in your client data sheet make one additional column combining &a1&" ,"&b1& the customer name with the invoice and preserving your existing columns. And when you pull your slip, you grab from the combined column customer with invoice set up on your validation list cell. I did that with client's name combined with the date of birth. When 100 client's are in line and comes in front of me, I can spot fast the date of birth next to the name when I filter it to make sure I am pulling the right client when I ask the client his birth to see if his name matches.

[@zia-i]

wow, awesome!

[@AjayAnandXLnCAD]

Glad you think so!