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
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?
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 💚😃☑️
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?
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.
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
@@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
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 ?
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 :)
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?
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?
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!
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?)
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!
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.
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.
Hi any idea why this happen: when i click run, there’s a pop up error notification that says “sub or function not defined”. Can you help me how to solve this problem? Thank u in advance
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 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
I have a workbook that is 32 pages. It will work for the first 17 and then give me "runtime error 5" What am I doing wrong? All tabs are the exact same layout, 1 page each.
When I use this VBA code, I get this - Run-time error '91': Object variable or With block variable not set and it highlights the line .Title = "Select the Folder Path" line. Anyone want to chime in, I am just copying the code, I am not a programmer
This really is an excellent video, although I'm getting an error after the macro converts 7 to 10 worksheets to pdf before getting an error that says Run-time error '5' . I'm trying to get it to create like 80 worksheets at once. I wonder if there is a solution to that?
@@rachaelruszkowski2112 sorta? I don't think its really a good solution but try copying those tabs to a new sheet then execute the macro. Let me know if this helps for you because it helped for me.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
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
Very useful even in 2023 and further years . Thank you soo much bro
Welcome 👍
Simple and to the point explanation for this complicated task. Thankyou You saved my lot of time.
Most welcome🙏
Sir, You are done Very Very Good Job. Thank you Very Much
Most 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.
Thanks for your valuable feedback
Easiest macro I've viewed regarding this subject! Thank you! I'll be viewing more of your videos!
Thanks for your valuable feedback
True
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.
You're really brilliant man in excel and office tools
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
Great tutorial. Made my life really easy.
Glad it helped!
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
You are a life saver
Thanks a lot it works with me and the outputs were astonishing
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!
Thank you so much. This is brilliant!!! Exactly what I needed!
Most welcome
Excellent travail, merci pour ce partage.
Très bienvenu
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?
Saved me so much time, quick and to the point. Thank you.
Thanks for your valuable feedback
I was looking exactly this. Thank you
Most welcome
Extremely helpful! Thank you!
Thanks for your valuable feedback
Sir; thank you so much for your teaching, its one of the valuable things I ever learned
Thanks for your valuable feedback
I was hankering for this. Thank you. Helped alot
Thanks for your valuable feedback
Thanks Sir for Nicely explaining this difficult task
Thanks for your valuable feedback
Excellent Video !!!!
Thanks🙏
Waooo. This video is very Nice. Thank you so much Sir.
Thanks for your valuable feedback
THANK YOU! This was extremely helpful.
Thanks for your valuable feedback
Thanks sir very helpful
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
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.
ruclips.net/video/zcUYP_ZjhWw/видео.html
Took me sometime but YEEEEYYY!, THANKS A LOT FOR THIS!
Welcome!
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?
Incredible! Thank-you
Most welcome
Thank you!! Absolutely excellent! 😊
Thanks for your valuable feedback
Great video, I got the desired results. Thank you.
You're welcome!
excellent. so grateful 🥰
muchas gracias, muchas muchas gracias, no encontraba un ejemplo para este problema.
Gracias por ver
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?
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 video was very helpful easy to follow and worked great. Thank you.
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.
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
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
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?
Thank you very much... really helpful
Thanks for your valuable feedback
Many many thanks bro :-)
Most welcome
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
Really useful! Tks a lot!
Thanks for your valuable feedback
thank you very much i really appreciate ur useful work.
Thanks for your valuable feedback
Very clear 👍👌👍
Hi, this is awesome. Is there a way to only export selected sheets?
Yes, I will create a video on this topic.
very helpful. Thank you!
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
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
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 ?
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
I get runtime error 5 invalid code or argument at the line of sh.formatas pdf
Thank you so much Sir. Show me about mail merging and saving document as pdf
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
Thanks for sharing-Any idea why I'm getting a "runtime error 5. Invalid procedure call or argument" error?
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 :)
Very clearly, thank you.
Thanks for your valuable feedback
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
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?
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.
What do i have to change in the macro if i want to save only one of all in pdf form?
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?
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!
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?)
I am getting runtime error in sh.exportas fixedformat line, how to rectifiy sana
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!
Jabardast sir
Thanks for your valuable feedback
Works great! However all my PDFs are saved as an orientation of portrait I need them to be landscape. Please Help!
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. ?
Thank you Sir!
Welcome
you're amazing dude !!
Very Helpful
Thanks for your valuable feedback
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.
Does not work if the sheet contains more than 1 page in the print area... please help with this issue.
Nice 👍🏻
Thanks for your valuable feedback
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.
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.
Thanks for this video.......If only perticuler sheets are create in pdf then how can i do..
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
I have multiples workbook than how to do it plz suggest
Can we save as to pdf separate file, per page?
Hi any idea why this happen: when i click run, there’s a pop up error notification that says “sub or function not defined”. Can you help me how to solve this problem? Thank u in advance
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
Sir plzz make vba for partial match and also show maltipal results
I will try to make such video very soon
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
Thank u!
Most welcome
I have a workbook that is 32 pages. It will work for the first 17 and then give me "runtime error 5" What am I doing wrong? All tabs are the exact same layout, 1 page each.
Hii, Very usefull. But when I open the new PDF file, I didn't see anything of my worksheet? Any ideas?
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
When I use this VBA code, I get this - Run-time error '91': Object variable or With block variable not set and it highlights the line .Title = "Select the Folder Path" line. Anyone want to chime in, I am just copying the code, I am not a programmer
This really is an excellent video, although I'm getting an error after the macro converts 7 to 10 worksheets to pdf before getting an error that says Run-time error '5' . I'm trying to get it to create like 80 worksheets at once. I wonder if there is a solution to that?
Hey Matt, I was also looking into it, and the error is caused by too many tabs. still trying to figure out to how export large amount.
@@rachaelruszkowski2112 sorta? I don't think its really a good solution but try copying those tabs to a new sheet then execute the macro. Let me know if this helps for you because it helped for me.
@@rachaelruszkowski2112 Keep me posted if it worked!
Hi, I don't have the export button from the start in my home tab, what do i do?