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

Подписаться 272 тыс.

Просмотров 21 тыс.

50% 1

#ExcelAutomation #VBA
Hello Friends,
In this video, you will learn how to create an automation to create the bulk files for Excel, Word and PDF. Here we have used a school mark sheet template. This automation can be used for bulk Invoice creation or any other bulk file creation.
Please download the practice file from below given link:
www.pk-anexcelexpert.com/bulk...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

Опубликовано:

29 окт 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 63

@smarties1662 9 месяцев назад

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

@PKAnExcelExpert 9 месяцев назад

Thanks for your valuable feedback🙏

@fernandoperes5164 4 года назад

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 4 года назад

Thanks for your valuable feedback

@gokulnathpl 3 года назад

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

@rickkeev4919 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback.

@kineszg 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@Maliart944 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@info2satish 4 года назад

Awesome PK!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@MohAboAbdo Год назад

Thank you so much, Sir

@PKAnExcelExpert Год назад

You are most welcome

@gokerbg 4 года назад

Thank you.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@shoryaarora1464 4 года назад

Awesome 👏🏻

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@pgkannan 4 года назад

Thanks PK

@PKAnExcelExpert 4 года назад

Thanks for watching

@nktrendings816 3 года назад

Super BRO

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@lkumar2727 4 года назад

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.

@mstone8001 2 года назад

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 😀

@uniQue_XL 4 года назад

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 4 года назад

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

@uniQue_XL 4 года назад

@@PKAnExcelExpert Thanks!

@abufun1718 4 года назад

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

@sandhyarawat1768 4 года назад

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

@abhisheksinha4715 3 года назад

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..

@nrz332 2 года назад

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

@kiranarana7274 9 месяцев назад

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

@rahulshewale9206 4 года назад

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

@PKAnExcelExpert 4 года назад

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

@cmamallik674 4 года назад

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

@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

@KartikGilani 4 года назад

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

@SanviPatil2019 3 года назад

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..

@amitmishra1513 3 года назад

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