Automation: Bulk Files (Excel, Word and PDF) Creator in Excel VBA

[@smarties1662]

You are genius, easy explanation, fantastic work, many thanks!!!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@fernandoperes5164]

I have no words to thank you for your teachings ... exceptional work ... thank you very much !!! It will certainly be very helpful in my work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gokulnathpl]

You are amazing. I was searching similar video's, at last I got it. Thanks a ton.

[@rickkeev4919]

Another outstanding tool with endless potential; Thank you for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@Maliart944]

Thanks for sharing such useful tutorials. I have learnt many thing from your nice tutorials.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kineszg]

Thank you very much! This has made my task much easier!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mstone8001]

Hi PK! Newbie VBA peep here. This was so helpful but I have hit a snag! Unlike your setup, I have been trying to copy cell values from 1 workbook (wb1, .xlsm format, where the macro is saved) into some cells on another workbook (wb2, which is set out like a form/template of sorts) and then saving a copy of the filled-in wb2 ‘template’ as a workbook with a new name for each row of data in wb1. Wb2 belongs to another team, has visible sheets that are protected from editing plus several hidden worksheets. I have to save the whole workbook as a new workbook, to keep everything together. So I didn’t include the ‘nwb.Sheets(…..’ part of your code. After copying the values from wb1 into wb2 and creating the variable for the File_Name, I instead coded: Set nwb = ActiveWorkbook nwb.SaveAs Filename:”C:………\” & File_Name Nwb.Close False But the loop does not repeat. The code creates 1 (beautiful!) new filled-in .xlsx wb as a separate file, keeps wb2 open but wb1 gets closed! Try as I might, I can’t work out how to keep wb1 open, so the i as Integer can keep place and cycling through all the rows before stopping. I can’t make the wb2 template part of wb1, as you have in your awesome example and I have 700+ rows of data to save as separate forms urgently. I just don’t know how to fix this problem, so wb1 stays open and the loop works through it properly. Please help! And thank you in advance 😀

[@MohAboAbdo]

Thank you so much, Sir

[@PKAnExcelExpert]

You are most welcome

[@info2satish]

Awesome PK!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lkumar2727]

sir, pls can you refer any book and video for learn advanced excel...Thats why i am teaching to various Student..However want to be improve my technical skill in excel...pls help me how can be improve this You r really expert in excel..i think u r a best mentor for me who can give me good guidance.

[@nktrendings816]

Super BRO

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@uniQue_XL]

Thanks! very nice example and explantion. Is it possiable to copy the table into an exsiting Word Document, an a specific spot/row on the Word Document?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes this is possible. I will definitely try to make such video.

[@uniQue_XL]

@@PKAnExcelExpert Thanks!

[@shoryaarora1464]

Awesome 👏🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SanviPatil2019]

सर क्या हम इसी तरह Pay sleep generate कर सकते है.. word, excel, pdf

[@PKAnExcelExpert]

Yes, we can do

[@SanviPatil2019]

@@PKAnExcelExpert सर तो इसका वीडियो बनाओ

[@PKAnExcelExpert]

Will upload soon

[@kiranarana7274]

Please help, when I change the name of directory on Sheets("Settings").Range("F4") I get error directory is not exist, I need to create directory manual, below VBA is working if the directory not change, it's possible to add vba if directory not exist wil be create automaticaly. Thank you

[@SanviPatil2019]

Sir kya yahi vba code through hum salary pay slip word,pdf, excel me generate mar sakte hai.. Data file.me employee name basic, g.pay, hra., D.a. Gross salary, pf. Tds.advance. loan.. net salary.. karke. Next sheet me automatically all employee ki salary sheet hum bana sakte hai kya..

[@abhisheksinha4715]

Hi sir.. Can you help me to get the vba code to select dynamic range for pdf generation.. I mean invoice can be of one, page and more..

[@KartikGilani]

Sir, Please write add a small code for rename sheet "Automatically Change Worksheet Names Based On Cell Values || Rename Excel sheet with cell contents" in this code ..Example Cell is Roll Number..Hence the output filename should be Master Template_Roll Number

[@pgkannan]

Thanks PK

[@PKAnExcelExpert]

Thanks for watching

[@project2jyotipublicity4]

When i click on pdf export it is coming as Runtime Error 5 with debugging taking me to following line tsh.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Sheets("Settings").Range("F4").Value & "\" & File_Name Files are not getting exported

[@amitmishra1513]

Hi Nice explanation Need to split pdf file by range and range will mention in excel cell vba code and by same way need to merge pdf files pdf file name is available in A excel

[@sandhyarawat1768]

Thank you Sir for this video, Sir how we can prepare certificates generator (automation)in word and pdf format using vba

[@cmamallik674]

Which is the best way to learn vb coding. Please let me know

[@abufun1718]

Very Excellent Job, Is there any way to export all the files in one PDF or One WordFile instead of separate files?

[@hasmukhnirmal1263]

Very very like Kya me ise use kar sakta for invoice

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes you can use invoice also just change the template and some coding accordingly.

[@hasmukhnirmal1263]

Thanks

[@afzalkhanmiefellow8661]

Excellent but can generate single pdf file for each record instead of multiple pdfs?????

[@PKAnExcelExpert]

Yes, you can. Just need to change the code accordingly.

[@afzalkhanmiefellow8661]

@@PKAnExcelExpert plz share the code for all record in single pdf

[@rahulshewale9206]

Thanks sir so much , Could you please make pivot table vba ?

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try to make such video very soon.

[@gokerbg]

Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@academicdeanerode3295]

Sir How to bring students marks with charts . Please guide me

[@punyakafle1873]

Want to make all in one word file of pdf file. How can I do it, sir?

[@saurabh17sharma68]

Sir Advance excel ko strong kaise kare

[@tahjibhassanrhythm40]

Sir can you please help generating a single PDF instead of separate PDF files for each rows?

[@CpTiga-d2c]

how to make it only in one file, not into separate files

[@kumargoodvideoscreation9582]

Sir please 1 more video make excel VBA pdf and word auto creat with step to step explain excel with VBA

[@Saadvik.KB.91]

Automation bulk file for (incomtax calculator and form 16a&b) in excel sir

[@nrz332]

Hi sir, great video. Just want to ask if we can add password to these files? Great work sir👏

[@krishnajagadeesh6307]

How to compine all pdf file in single file

[@kumargoodvideoscreation9582]

Kindly request you I stand how to write PDF and Word File auto generated in excel VBA so request you please explain step to step.

[@ausalam1]

There is one Error in your program.. Hindi marks always shows as 76.. and average shows as wrong.. may be shifting of one row cause this error..

[@PKAnExcelExpert]

Thanks for highlighting the issue. I have made the necessary changes. Please download the updated version.

[@yasminwazeer4735]

Want to learn coding but failing again n again