Automation: Word to PDF Converter in VBA || File System Object Method || Convert Multiple Word files

#WordToPDFConverter #FileSystemObject #VBA
Hello Friends,
In this video you will learn how to create a Word to PDF converter using VBA. This converter can convert multiple Word file into PDF on single click.
Please download this excel file (Converter) from below given link:
www.pk-anexcelexpert.com/auto...
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

[@angelodeocampo3643]

Bro, you are my life saver...works smoothly.. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ramziadil2189]

Thank you so much you're a genius!!!

[@PankajKumar-yn3lx]

Thnx boss, This is most use full.

[@caruanagiacomo3322]

wow thank you pk very handy

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Swamhtetyan]

Thank you for share knowledge

[@fondzewongwiyfenglaanslem4563]

You are just the best. A nice teacher. Be blessed
you helped me

[@PKAnExcelExpert]

Thanks for your valuable feedback 😀

[@n1ch1r1n6]

Thank you for the hard work you've put on this tutorial. Works like a charm.

[@PKAnExcelExpert]

Glad it helped

[@marcusbodeck2962]

Hey Bro .... I love you THX ... Now i can work 10000 times faster .... no jocke ^^

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@andreprado1]

Perfect!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fabiobvn]

Excelent my friend! Thank U so much 🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@LongNguyen-kz2oe]

I did it, thank you so so much Bro

[@PKAnExcelExpert]

Welcome 👍

[@hanikoariellozano2726]

Thank you very much sir. now i don't have to go online to convert word to pdf. thank you!!!!

[@PKAnExcelExpert]

All the best

[@papaliahomeservices1852]

This was amazing! What if you wanted the filename to be from a fixed spot within the word doc?

[@KundanKumarTantia]

Gr8t job. Kindly add a button for browse file path instead type of path.

[@geresh12]

Thanks for the showing this, how can we change the folder path to teams folder

[@bhai5608]

Superb....!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hazelness7]

that is excellent! is it possible to combine excel file, word file and pdf file into one pdf? would really appreciate if you can make a tutorial for that. thanks in advance☺

[@karlvernor1690]

Absolutely brilliant video. Subscribed to yiur channel. Can i ask how you learnt vb? Thank you

[@rakeshshamantula6283]

Thank you for the video. It is really helpful. How do I convert tiff files to pdf?

[@muthuraja6589]

Pk sir I have a Data in three different Sheets, however I need to get all the existing three sheets data to new working Excel file using VLOOPUP function

[@abdulhamidalhaddadi2255]

Great Idea,
Sir I have a question, how can I convert file ONE by ONE? because I have registration sheet more than 100 records.
I am waiting your reply
Thank you

[@maddinenirajeshbabu3143]

Thanks for your video PK I am having one doubt how to open protected pdf file using vba

[@ITCBI-ve2rx]

Can we play with sequencing of these word files and merging as well

[@user-it1oo4cz8w]

Dear brother How can I delete a row in a spreadsheet without compromising the data outside the table and on the same page by a button in the ezervum by the code.
Thank you and appreciation

[@AshwinKumar-ss1ky]

HI Sir,
Can we convert JPG to pdf by using same logic, please suggest.

[@mukundpotdar9849]

Hi Sir,
I m looking for VBA Code where you want to use mail merge and generate document individual and employee code wise and convert into pdf. This is for generating increment letter for multiple employees.

[@carollui2220]

Hi, I have a question. The pdf contains 2 pages (the 2nd page is blank) after converted. I think it's margin issue. Could you please advise the code that I can deletle Page 2 when converting? Thank you very much!

[@JoseFernandezM]

Puede hacer un video donde ser convierta de word a pdf con contraseña?

[@Stacyryan3]

What needs to be changed in the code for converting rtf to pdf since replacing .docx with .rtf is not converting ... Any help ?

[@FRAN-vd9rl]

hi, does this code distinguish if i have other file extensions in that folder for ignoring them and only taking the .doc and .docx files?

[@satyanarayanakinjangi9517]

Sir when I used the above VBA code to convert word files to pdf files, it shows "another application to complete an ole action". I used microsoft excel 2007. So plz clarify my doubt. And resolve the problem.

[@rajashukla3033]

Hi Sir, do you have a similar tool for converting PDF into word doc ??? please revert...

[@kiranghadi7088]

I am using office 16 and "dim wordapp as new word.application" not supported

[@sookchern87]

Hi, may I know if you able to convert Word file with multiple pages and convert to multiple PDF files with password encrypted at once?

[@vishalsingh127]

Heloo bro i need your help for vba se folder crate krna and autofillter sheet se newwork book bane our save ho jaye ek folder me pls share the solution

[@jacekrischka9523]

Hello:) I wrote the code in Excel, Microsoft Office 365 on Windows 10. When I click the button it pops up: Compile error: Invalid or unqualified reference. Can you please suggest any solution?

[@selvarasan.v7246]

Please request for help I try to VBA one VBA code error show _The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.

[@aranyamajumdar9007]

Can you please share one more code for tiff images to pdf by excel macro

[@yogeshdesai3049]

Sir how to mail merge labels with vba in excel user form

[@PankajKumar-yn3lx]

Hi sir, I want vba script for pdf file size reduce. Pls suggest me sir.

[@PankajKumar-yn3lx]

Sir now not convert this process in window 10. Please suggest me.

[@pramodml2725]

Hi Sir, How to convert PDF file to excel file ?

[@abhisheksaraswat6753]

Hi Sir, How we can consolidate the PDF using VBA...

[@PKAnExcelExpert]

I will definitely try to make such video very soon.

[@MIS_PRODUCTION_AAA]

Convert each pages into pdf

[@mithunmitra1]

I am getting an error in coding, can you please help me

[@chaiyya345]

I have downloaded the file & not working.
Run-time error '4198'
Command failed

[@PKAnExcelExpert]

Which version of office are you using and what is the extension of your word files like .Doc or .Docx?

[@chaiyya345]

@@PKAnExcelExpert
Office Home & Business 2016
.docx

[@chaiyya345]

@@PKAnExcelExpert Hi,
I managed to convert all my docx files but often hit with errors. several errors i have seen:
1. Run-time error '4198' Command Failed
2. Run-time error '-2147467259 (80004005)' This file is in use by another application or user
3. I have checked on Debug & VBA pointed me to this line:
Set worddoc = wordapp.Documents.Open(f.Path)
worddoc.ExportAsFixedFormat sh.Range("E14").Value & Application.PathSeparator & VBA.Replace(f.Name, ".docx", ".pdf"), wdExportFormatPDF
Once it failed, it can no longer run the next conversion & i can see from the progress bar the docx is increasing by 1 file (eg, my Word folder has 12 files but from excel progress bar shows "Processing... 5/13)
Do u think u could debug this further?
Thank-You very much