Free Excel VBA Course #36 - Save Excel File as PDF using VBA (Entire Workbook or Individual Sheet)

[@gopikasnair2813]

Superb playlist. Bless you..

[@umeshsutar6339]

Came across first course in you tube which is really helpful to learn Excel. Thank you so much for it!!

[@pratikshinde5625]

Just finished watching the whole VBA series, it was very insightful and thank you for such detailed videos.

[@GROWINGBUSINESSESBETTER]

I went through all of the course videos from video 1 to video 36 and appreciate all that you went over in the program. It was amazing.

[@margad-erdeneboldbaatar4704]

And again Thank you for this course. It's my third course /Finished/.

[@rtrbs8383]

Thank you very much for this series. I have Finished it and really awesome . Eagerly waiting for for part 2 of VBA Jet pack course.

[@fengfuxu4822]

great video, I will follow it to improve my work. thank you!

[@SaifAHadi]

Thank you Sir for simple and easy illustration.

[@eithar92]

Thank you it was so helpful and clear 🙏🏻🙏🏻🙏🏻🙏🏻

[@rodrigofa503]

You're my savior, thank you so much

[@delbatchio]

Excellent work!

[@harsh8334]

Great video ❤

[@faresal-anbar4545]

YOU ARE THE BEST

[@skvelu]

Thanks for the simple code. I used for my application.

[@alexa2294]

Thank you very helpful

[@thesscastaneda1179]

Thank you for this video. Supposed you have a template. How do you convert each row into pdf?

[@rdot21]

Thank you for this but my PDF is not exporting in the same folder as my excel file. my PDF is always showing up in the Documents folder for some reason?

[@ravindrabr230]

thanks that helped

[@CW77777]

Thankyou!

[@Vivek_Chauhan-ng4mo]

What to do next after completing this course?!

[@rishyrexytro540]

@trumpexcel Do I understand by this that having covered 36 videos is enough to have a VBA coding expertise?

[@trumpexcel]

It would give you a strong foundation and you would easily be able to work with basic and intermediate vba codes. The more you work with it, the more expertise you would gain. This course covers almost everything you need to know about VBA in Excel

[@muhammadbasher2466]

thank you.but sir if I want the pdf file to e-mail then what will be the vba code

[@sakshisharma-fo2hd]

Is it whole complete course for vba

[@tengcheeaun5229]

What if the sheet range selected page i wish to saved all in 1 page, what should i do ?

[@mohit8460]

I want to change the address from desktop to my difference drive? How to do this

[@coldplay5467]

Can you make a video on VBA formatting? My Word report is not showing the formatting I specified in the macro :(

[@nswaywayway]

how about combine 2 sheets into 1 pdf file?

[@vijaysahal4556]

duper hit sir 👍👍👍👍👍👍🤣

[@andytran4435]

Hello, thank you for your videos. Could you also make a video of how to create leave tracker? I would like to add emp code before name and have new sheet to track leave each month, year and entitlement leave.

[@bartoszplewa3788]

Excellent, final some one explain in detail how it's working, thanks

[@cmlosaria]

is there a way to export only certain columns (user is prompted to select which columns to export) as pdf?

[@rbrtktl]

Hi, It is a great video. But I have one question. Is it possible to export PDF to the folder if the path is submitted in a certain cell, for the user to be able to choose the direction?

[@ishratulislam]

I tried but the file is not saved in the same folder, it is saving in the documents folder all the time, please advise.

[@rakeshv7924]

Sir can you please make a video on how to divide worksheet in a excel file into different worksheet based on a criteria

[@anastasyalysyak5979]

Hi .trying to use it .after pressing on Alt f11 - i didnt see the name of the excel sheets .may be i need to presssomething else after Alt F11 ?

[@waseemlimbaliya6196]

Suppose its a employeee payroll sheet and want to save this file as pdf after incorporating passoword . Can it be done with VBA in excel ?? if yes then plz guid sir ....

[@kaviyarasu315]

Thank you sir, How to pdf lengthier column file

[@SalaryAnsaree]

thanks a lot sir............... any code for increase kb of picture but not change it size like(width=100, height=120... I want this is as is)

[@nagarjunatutika2002]

How to generate report contains range and chart in a same page

[@pm_ght1747]

Hi, just a question, how can you save a file to pdf using a filename which is stored in a certain range? If I have a referenced cell that will change its value over time, the pdf that will be exported will be the same name as the stored value on the referenced cell. I had tried to create a variable that will store the name that will be inputted on the referenced cell, but I have a hard time joining it to have an output of pdf with a filename same as the stored value. I hope you can help me with this. Thanks

[@mabellevaldeleon9975]

Is there a way to combine two sheets into 1 pdf file? please help?

[@SanjayDevani]

Hi, Thank you for sharing, kindly let me know if sheet1 and sheet4 i want to export pdf in one page? is there any formula for that. thank you in advance

[@mohamedfareed8858]

HOW CAN I COMBINE THSES PFDS ?

[@dadosinteressantesdecacana582]

Thank you for the lessons. I wrote a macro to open my workbook with a new number every time (+1), but I also would like to have a button to save the workbook to a specific location as .xlsx after I input the data, then clear the contents and be ready for the next one. I can perform both in separate workbooks but I'm having trouble combining them all in one workbook. Any help?

[@cpkanojiya]

How can I make pdf of every page of excel file and email.

[@Story.Express-1]

Hi, how to create PDF file with protected password?. Please help

[@ahmedsaad7870]

hi Sumit.can i save the form as PDF?

[@flemmingstaal4819]

I ends up with a Run-Time error "1004" Method "ExportAsFixedFormat" of object _Worksheet failed

[@mohitgupta1926]

hi Sumit, Thanks for sharing the video. I am facing the problem that it is not creating any pdf also it shows Runtime error 1004

[@satishkumar-bp3op]

I am facing a problem run time error '5' Invalid procedure call and argument

[@husseinrefaat2287]

Thank you very much for this video, very helpful and easy to follow. Is is possible to exclude one or more tabs from being saved as PDF? For example, I have a workbook with "Course manager" "SIM Prac" "Overview" & "Learner 1" "Learner 2".. up to "Learner 15" (number of learners vary for each course). I want to save only the learners worksheets as separate PDF files. I also want the PDF files to be saved with the learners names & staff numbers which are 2 different fields on each worksheet. Finally, I want to assign the macro to a button on the "Course manager" worksheet. Appreciate your assistance :)

[@piyushvasani923]

how can we name the file name as per specific cell in worksheet ?

[@ronakgujarathi]

How to use this same code using command button

[@marivi6947]

what is the difference of inserting a module by adding through insert menu and right clicking at any sheet in VBA project?

[@LearnYouAndMe]

No difference, both are same or alternatives

[@lashajw]

i want sheet nam to range convert. not want name "range". halp

[@rajeshshah6758]

Hello Sir, I am trying to create a VBA macro where I can copy data from excel and paste it to another application, i.e., Notepad++ and save it on the desktop in XML format. This is one part of it. Can you help me with this.?

[@jigsinos]

how can you save only specific sheets in a single pdf eg sheet1,sheet 3, sheet5 in one pdf

[@ravikhande1546]

Can we make PDF uneditable ...???

[@dwaynewilson3263]

how do you save a worksheet as a pdf that is set up in a landscape mode and not Portrait .

[@genetresom2380]

Summit, is there any way to add suffix numbers to exported files to prevent overwriting of previous ones?

[@miked6592]

You can create a counter in a cell. Each time you run this code, add +1 to that cell (first) and then use that cell value within your name string.

[@paramjeet975singh3]

Vba is better than excel but when will u upload that video in which we can see vba is far better than excel.. Plzz

[@shivanimahida5544]

Im struggling :(

[@nakibkhan443]

I received message " Run time error 5 " while running program, please inform mistake.

[@nakibkhan3249]

I am getting run time error 5 while running code. Please inform how to correct.

[@jitenndermodgiil361]

try this but not save & print

[@Themanofideas94]

Not working

[@luisbordones7627]

I wish I could actually see the video. It is so blurry. I can see what he is typing

[@anhnhatnguyet4628]

-- Export and Save an entire Excel workbook as PDF -- Export a specific worksheet as PDF I work but not success. NO PDF FILE IS EXPORTED

[@whereisthevolume3648]

i have same issue waste of time

[@jubileelifeinsurance5991]

Respected Sumit, Hope you will be fine, i have sent you an email kindly reply me. I want to learn you more. YOU ARE GR8 !

[@simonteunis]

How you save sheet1 and sheet3 in one PDF.