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!!!
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
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 💚😃☑️
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
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.
@@MrDecarte were you able to figure this out? I'm getting the same debug error. I also notice when I type the script ".exportasfixedformat" the only prompt I get is for XPS, no option for PDF. When I manually type the script as shown in the video I get the debug error highlighting that line if code. @PKAnExcelExpert please help?
It works great on the worksheets without any other VBA; however, the worksheets that I have some other VBA command, it would not work. Do you have any other way for worksheet that have other vba?
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
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"
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.
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?
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 ?
@@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
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?
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?
Hello there PK! I'm getting a "run time error '5'" Invalid procedure or argument" when I run the macro. When I debug it highlights: " sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf" are there any edits I can make to this to make this work?
If figured it out. If there are any hidden sheets, or sheets with no content, this error will appear. Can you change the code to account for hidden sheets? (ignore them?)
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 :)
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!
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?
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
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.
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!
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!!!
This was exactly what I needed to print multiple Excel tabs into individual PDFs. Super easy and great explanation! thank you!
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!
You're welcome!
Thanks for the Macro. I used it to generate 100 excel based BINGO CARDS. It worked like a charm!
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....
Glad it helped
Simple and to the point explanation for this complicated task. Thankyou You saved my lot of time.
Most welcome🙏
Very useful even in 2023 and further years . Thank you soo much bro
Welcome 👍
Easiest macro I've viewed regarding this subject! Thank you! I'll be viewing more of your videos!
Thanks for your valuable feedback
True
Great tutorial. Made my life really easy.
Glad it helped!
Thank you so much. This is brilliant!!! Exactly what I needed!
Most welcome
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
Thanks for your valuable feedback.
Sir, You are done Very Very Good Job. Thank you Very Much
Most welcome
Excellent travail, merci pour ce partage.
Très bienvenu
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.
Thanks for your valuable feedback
You are a life saver
Thanks a lot it works with me and the outputs were astonishing
Thanks for your valuable feedback
I was looking exactly this. Thank you
Most 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 💚😃☑️
Thanks for your valuable feedback
You're really brilliant man in excel and office tools
Thanks for your valuable feedback
Saved me so much time, quick and to the point. Thank you.
Thanks for your valuable feedback
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 ^_^
Thanks for your valuable feedback
muchas gracias, muchas muchas gracias, no encontraba un ejemplo para este problema.
Gracias por ver
excellent. so grateful 🥰
Extremely helpful! Thank you!
Thanks for your valuable feedback
THANK YOU! This was extremely helpful.
Thanks for your valuable feedback
I was hankering for this. Thank you. Helped alot
Thanks for your valuable feedback
Waooo. This video is very Nice. Thank you so much Sir.
Thanks for your valuable feedback
Thank you!! Absolutely excellent! 😊
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.
Thank you so much!
Incredible! Thank-you
Most welcome
Thanks sir very helpful
Most welcome
Thank you Sir, you're a true expert.
Took me sometime but YEEEEYYY!, THANKS A LOT FOR THIS!
Welcome!
This video was very helpful easy to follow and worked great. Thank you.
PK, thank you! Video was great and taught me to do exactly what I was hoping to do.
Sir; thank you so much for your teaching, its one of the valuable things I ever learned
Thanks for your valuable feedback
Very clear 👍👌👍
Great video, I got the desired results. Thank you.
You're welcome!
Excellent Video !!!!
Thanks🙏
Thanks Sir for Nicely explaining this difficult task
Thanks for your valuable feedback
Thank you very much... really helpful
Thanks for your valuable feedback
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
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.
Hi, thanks for the video but I get a run time error '424' any way to fix this
@@MrDecarte were you able to figure this out? I'm getting the same debug error. I also notice when I type the script ".exportasfixedformat" the only prompt I get is for XPS, no option for PDF. When I manually type the script as shown in the video I get the debug error highlighting that line if code. @PKAnExcelExpert please help?
Many many thanks bro :-)
Most welcome
thank you very much i really appreciate ur useful work.
Thanks for your valuable feedback
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?
This guys shows you how to do that.
th-cam.com/video/zcUYP_ZjhWw/w-d-xo.html
very helpful. Thank you!
Thanks for your valuable feedback
Really useful! Tks a lot!
Thanks for your valuable feedback
Do you have a macro that will take the subtotals from the main sheet and export the results for each subtotal to the individual sheets?
Very clearly, thank you.
Thanks for your valuable feedback
Thank you Sir!
Welcome
Thank u!
Most welcome
thank you
Most welcome
Nice 👍🏻
Thanks for your valuable feedback
O_O wow....thanx man.
Any way to exclude one or more sheets from being exported?
I will upload a video on this topic soon
Hi, this is awesome. Is there a way to only export selected sheets?
Yes, I will create a video on this topic.
Thank you very much!
It works great on the worksheets without any other VBA; however, the worksheets that I have some other VBA command, it would not work. Do you have any other way for worksheet that have other vba?
Very Helpful
Thanks for your valuable feedback
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
What do i have to change in the macro if i want to save only one of all in pdf form?
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"
If I have the data only in one worksheet and data is repeated then hot to save the file into PDF.
Can we save as to pdf separate file, per page?
Thank you for the Video. How to Export only the Selected Excel Worksheets in the same way? What should I change in the code?
Select the sheets you need and change this line of the code:
For Each sh In ActiveWindow.SelectedSheets
I have multiples workbook than how to do it plz suggest
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.
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.
nice
Thanks🙏
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?
Does not work if the sheet contains more than 1 page in the print area... please help with this issue.
Good.
Thanks
I get runtime error 5 invalid code or argument at the line of sh.formatas pdf
Thanks
Welcome
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 ?
Jabardast sir
Thanks for your valuable feedback
Great Video! Is there a way to setup "Fit Sheet on One Page" by default for all worksheets when saving as PDF?
looking for the exact same thing here
@@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
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?
No work with me why
Show me ( run-time error 5
Invalid procedure call or argument
Can u help me
I have the same error
Do you have any hidden sheets? I did and after I unhid them, it worked
this is magic
Thanks🙏
After creating PDF with the help of macro, the page set was not good can i know how to create pdf with all columns in one page.
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?
I am getting runtime error in sh.exportas fixedformat line, how to rectifiy sana
Works great! However all my PDFs are saved as an orientation of portrait I need them to be landscape. Please Help!
Thank you so much Sir. Show me about mail merging and saving document as pdf
Hello there PK! I'm getting a "run time error '5'" Invalid procedure or argument" when I run the macro. When I debug it highlights: " sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf"
are there any edits I can make to this to make this work?
If figured it out. If there are any hidden sheets, or sheets with no content, this error will appear. Can you change the code to account for hidden sheets? (ignore them?)
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 :)
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
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!
Thanks for sharing-Any idea why I'm getting a "runtime error 5. Invalid procedure call or argument" error?
Hi, I don't have the export button from the start in my home tab, what do i do?
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?
Thanks for your valuable feedback. Yes it is possible. You have to make some change in the code
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
Is it also possible to add the current date to the PDF file names within the Macro with the Tab Names? so Tab Name - Current date.pdf
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.
instead of "sh", I changed it to "ws". It perfectly works now.
How if I only want save the print area on specific worksheet?
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
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 Pdf created but content is not showing
Sir i m error " Run- time error '1004'
Can we make PDF uneditable ...???
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!