This was exactly what I needed to print multiple Excel tabs into individual PDFs. Super easy and great explanation! thank you!

@PKAnExcelExpert

Жыл бұрын

Glad it was helpful!

Thank you so much! I know very nearly nothing about programming or macros and your instructions and modeling worked perfectly. You've saved me hours!

@PKAnExcelExpert

2 жыл бұрын

You're welcome!

Thank you sir! I'm out of school by a few years and never got too involved with excel macros, but you made it really easy.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

I just received an excel file with 15 sheets, which I had to make in different PDF files... You saved me from a boring job... Just copied your code and .... BOOM!!! Done in seconds! Awesome... Its the first time I've come across your channel... You're awesome!!!

Thanks for the Macro. I used it to generate 100 excel based BINGO CARDS. It worked like a charm!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you so much!!! I have never created a macro and was intimidated by the process, but your video was clear and easy to follow. You actually made me feel like I can learn and do hard things...lol

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback.

Easiest macro I've viewed regarding this subject! Thank you! I'll be viewing more of your videos!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

@shyamsunderac1557

3 жыл бұрын

True

Saved me so much time, quick and to the point. Thank you.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you Sir, you're a true expert.

PK, thank you! Video was great and taught me to do exactly what I was hoping to do.

You're really brilliant man in excel and office tools

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

This video was very helpful easy to follow and worked great. Thank you.

Simple and to the point explanation for this complicated task. Thankyou You saved my lot of time.

@PKAnExcelExpert

10 ай бұрын

Most welcome🙏

Very useful even in 2023 and further years . Thank you soo much bro

@PKAnExcelExpert

Жыл бұрын

Welcome 👍

Sir; thank you so much for your teaching, its one of the valuable things I ever learned

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

You have a beautiful and simple way of explaining things. It is wonderful. Keep it up and help all of us out here more and more. Stay safe.

@PKAnExcelExpert

4 жыл бұрын

Thank you so much!

Extremely helpful! Thank you!

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback

You are a life saver Thanks a lot it works with me and the outputs were astonishing

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

THANK YOU! This was extremely helpful.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Wonderfully explained without any knowledge I have created one and it's working fine❤❤❤❤❤ Saved atleast many hours of my life....

@PKAnExcelExpert

10 ай бұрын

Glad it helped

Thank you very much!

Thank you!! Absolutely excellent! 😊

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you so much. This is brilliant!!! Exactly what I needed!

@PKAnExcelExpert

7 ай бұрын

Most welcome

Incredible! Thank-you

@PKAnExcelExpert

Жыл бұрын

Most welcome

Very clearly, thank you.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Very clear 👍👌👍

I was hankering for this. Thank you. Helped alot

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Great video, I got the desired results. Thank you.

@PKAnExcelExpert

4 жыл бұрын

You're welcome!

I was looking exactly this. Thank you

@PKAnExcelExpert

Жыл бұрын

Most welcome

How did I not discover this when I was in my high school days?? Thank you so much, sir... I really learn a lot and you helped me as well ^_^

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback

Really useful! Tks a lot!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

very helpful. Thank you!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Great tutorial. Made my life really easy.

@PKAnExcelExpert

5 ай бұрын

Glad it helped!

thank you very much i really appreciate ur useful work.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thanks Sir for Nicely explaining this difficult task

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Took me sometime but YEEEEYYY!, THANKS A LOT FOR THIS!

@PKAnExcelExpert

10 ай бұрын

Welcome!

Very clearly explained as always PK. I really like the tips on adding the macro to a button on the ribbon - I will put a link to this bit on a video I have coming out soon on my channel as you explain really well 💚😃☑️

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you very much... really helpful

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you Sir!

@PKAnExcelExpert

3 жыл бұрын

Welcome

Excellent Video !!!!

@PKAnExcelExpert

2 жыл бұрын

Thanks🙏

This is exactly what I was looking for! At some point, will you show us how to build the same kind of macro to save them as separate excel sheets?

@DavidGomez-le7if

Жыл бұрын

This guys shows you how to do that. kzread.info/dash/bejne/rJeJu7KYis3Oh9o.html

Thanks so much.. really helped me.

@PKAnExcelExpert

Жыл бұрын

Glad it helped!

Excellent travail, merci pour ce partage.

@PKAnExcelExpert

Жыл бұрын

Très bienvenu

muchas gracias, muchas muchas gracias, no encontraba un ejemplo para este problema.

@PKAnExcelExpert

11 ай бұрын

Gracias por ver

Many many thanks bro :-)

@PKAnExcelExpert

2 жыл бұрын

Most welcome

Waooo. This video is very Nice. Thank you so much Sir.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank u!

@PKAnExcelExpert

Ай бұрын

Most welcome

Very Helpful

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you for the video. I have one worksheet that I am trying to split out into several PDF's based on the data. Will this VBA macro work for that scenario but use a Do while loop or another VBA loop ?

Hi. Thank you for your video. It is extremely helpful. I have a question that. Could you improve your vba so that each pdf files will be encrypted with specific passwords list one specific cell of individual sheet?

Jabardast sir

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you for this video it is very helpful please let me know how to export specific sheet in sprate PDF, I mean sheet array export

Lovely video yet again...Sir, please tell what to do, if i want to save all worksheets in one pdf file...not separate pdf files...

Hi. Thanks a lot for this! With this code, how do I enable Pdf save even with the worksheets in Page-break view mode or some sheets hidden? There is almost 300 worksheets!

this is magic

@PKAnExcelExpert

8 ай бұрын

Thanks🙏

Nice 👍🏻

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

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". 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 :)

Thanks

@PKAnExcelExpert

Жыл бұрын

Welcome

This is PERFECT! Thank you! I only have one question. When I click [Cancel] when the Select Folder Path box comes up I get the following error "Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving." How would I just make the Macro stop at that point?

Good.

@PKAnExcelExpert

Жыл бұрын

Thanks

Thank you! I was getting a Runtime Error 5: Invalid Procedure call or argument. Another forum calls out that hidden and very hidden sheets throw this error when ExportAsFixedFormat is called on them. I unhid my sheets, and it worked!

@czlvsezful

Жыл бұрын

Thanks for that info I was wonder what was going on with my export for the last 30 mins.

It works well, ty! Is it possible to do this with Sheet1, Page1 = 1.pdf; Sheet1, Page2 = 2.pdf; Sheet2, Page1 = 1.pdf; Sheet2, Page2 = 2.pdf etc. ?

Sir, if I want to give file name as per any cell value. Please advise Your videos are so helpful I m you big fan.👌

you're amazing dude !!

This is exactly what I was looking for. A true time saver. I tried this on my file that has 50 worksheets, and I kept getting an error on this line: sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf". To test if I had exceeded the number of worksheets, I saved 4 worksheets out and ran the Macro again, and it worked. Can you tell us what the maximum number of worksheets this macro will accommodate? I know it's less than 50, but if you could give a precise number that would be greatly appreciated. Thank you.

@sathyalakshmi7103

Жыл бұрын

I am having the same issue

hi sir when i select the destination folder path and it showed "Open" instead of "OK". so i can't proceed further. Appreciate if you can help.

I don't have any knowledge of VBA, but it worked out. Great! But now I have a question: I have an Excell file I use a lot. In this Excell file I have 16 different worksheets and with this macro I export all the 16 worksheets. But i only want 8 specific defined worksheets to be exported to 8 seperate PDF files.. How can I do this?

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback. Yes it is possible. You have to make some change in the code

nice

@PKAnExcelExpert

Жыл бұрын

Thanks🙏

Thank you! I'll be viewing more of your videos & made. I working so good but the total worksheet was 50 when 13th sheets pdf complete then this message is shown yellow & input error found. sh.ExportAsFixedFormat xlTypePDF, folder_path & Application.PathSeparator & sh.Name & ".pdf" Dear Please advise me how can i get complete pdf all worksheet in excel.

Hii, Very usefull. But when I open the new PDF file, I didn't see anything of my worksheet? Any ideas?

O_O wow....thanx man. Any way to exclude one or more sheets from being exported?

@PKAnExcelExpert

2 жыл бұрын

I will upload a video on this topic soon

Great Video! Is there a way to setup "Fit Sheet on One Page" by default for all worksheets when saving as PDF?

@BoBoNoi

2 жыл бұрын

looking for the exact same thing here

@AEshowseverything

Жыл бұрын

@@BoBoNoi Select all tabs > Page layout > printer tiles > Printi preview > make changes to suit > go back > tabs should all have same printing options. worked for me

Thanks for this video.......If only perticuler sheets are create in pdf then how can i do..

Thank you for the Video. How to Export only the Selected Excel Worksheets in the same way? What should I change in the code?

@gustavomarcos1238

Жыл бұрын

Select the sheets you need and change this line of the code: For Each sh In ActiveWindow.SelectedSheets

Hello PK, thank you for the helpful video! Is there a way to concatenate the file name that is being exported? For example, I want to create a unique file with the same prefix ""April Costs Centers 24" & "sh.Name" & ".pdf" ... How would I include this variable inside the formula you shared? For Each sh In ActiveWorkbook.Worksheets sh.ExportAsFixedFormat xlTypePDF, folder_path & Application.PathSeparator & "WORKBOOK NAME (Cost Centers 24)" & sh.Name & ".pdf"

Works great! However all my PDFs are saved as an orientation of portrait I need them to be landscape. Please Help!

Hi, I don't have the export button from the start in my home tab, what do i do?

Nice sir, till now I have not watched this sir…💐💐💐 Sir if I need this in my sheet, Can I copy and paste the code sir… or download this file sir

I am getting runtime error in sh.exportas fixedformat line, how to rectifiy sana

Hi PK, Thanks for the video but I get too an debug error msg at the line sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf" Any fix? thanks

@daveconway8087

3 жыл бұрын

I had this issue as well, and it was because one of my first sheets was blank. To fix it, just add text in any cell in the sheet, and it should work if it was the same error.

@kejalrawal1170

2 ай бұрын

Hi, thanks for the video but I get a run time error '424' any way to fix this

Thanks for sharing-Any idea why I'm getting a "runtime error 5. Invalid procedure call or argument" error?

Hi, this is awesome. Is there a way to only export selected sheets?

@PKAnExcelExpert

2 жыл бұрын

Yes, I will create a video on this topic.

Hello, Have a problem, I did like You show here. But it give me error Run-time error 5: Invalid procedure call or argument, but video is very good.

How if I only want save the print area on specific worksheet?

How would I make it if I need to select Fit to Page Width as an option

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?

Can you help me I want to make seperate pdf of a result in which when we enter the roll no. We get the child's result and then we have to make pdf from it can you tell a way to make all the PDFs of the children's result at once (the pdf should be of selected region only and should be shown only on one page of the pdf) This will help a lot of teachers

I get runtime error 5 invalid code or argument at the line of sh.formatas pdf

I have multiples workbook than how to do it plz suggest

What do i have to change in the macro if i want to save only one of all in pdf form?

I'm not sure why the code doesn't want to work with this one particular workbook I have. I keep getting an error "Run-time error '5': Invalid procedure call or arguement" after I choose my destination of where to save the PDFs

If I have the data only in one worksheet and data is repeated then hot to save the file into PDF.

Hi I run into this error: "Method ExportasFixedFormat" of object "_Worksheet" failed. I checked many times, everything was right. One weird thing is it exported the first tab out correctly, but failed to export the second. Please help!

Can we save as to pdf separate file, per page?

Hi, This worked perfectly other than I do not get the Done message and i receive an error Invalid Procedure Call or Argument. Does anyone see anything incorrect? The files do get created. Sub SavePDF() Dim Folder_Path As String With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Select the Folder Path" If .Show = -1 Then Folder_Path = .SelectedItems(1) End With Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf" Next MsgBox "Done" End Sub

Sir plzz make vba for partial match and also show maltipal results

@PKAnExcelExpert

4 жыл бұрын

I will try to make such video very soon

Hello! I tried this VBA, however, when I exported it, all the files have the same content (using the active sheet), only file names were changed based on the tab sheet name. Have you checked on this? Thanks.

@chrisdalupan

3 жыл бұрын

instead of "sh", I changed it to "ws". It perfectly works now.

Sir 150 Halltickets single pdf file excel to selected students Halltickets print vba code any possible sir please explained

I had this macro and it worked, now all of a sudden it gave me run-time error 5, and have no idea why and how to sort it. Can someone please help? Many thanks

Does not work if the sheet contains more than 1 page in the print area... please help with this issue.