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

[@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

[@bhai5608]

Superb....!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@caruanagiacomo3322]

wow thank you pk very handy

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@marcusbodeck2962]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@angelodeocampo3643]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@geresh12]

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

[@LongNguyen-kz2oe]

I did it, thank you so so much Bro

[@PKAnExcelExpert]

Welcome 👍

[@ITCBI-ve2rx]

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

[@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!

[@PankajKumar-yn3lx]

Thnx boss, This is most use full.

[@ramziadil2189]

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

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

[@maddinenirajeshbabu3143]

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

[@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?

[@karlvernor1690]

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

[@Swamhtetyan]

Thank you for share knowledge

[@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

[@fabiobvn]

Excelent my friend! Thank U so much 🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@Stacyryan3]

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

[@AshwinKumar-ss1ky]

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

[@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

[@ابوفيصل-ت2ي]

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

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

[@rakeshshamantula6283]

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

[@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

[@JoseFernandezM]

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

[@pramodml2725]

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

[@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

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

[@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☺

[@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?

[@rajashukla3033]

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

[@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?

[@andreprado1]

Perfect!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abhisheksaraswat6753]

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

[@PKAnExcelExpert]

I will definitely try to make such video very soon.

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

[@mithunmitra1]

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

[@vaibhavsampat8039]

How to covert multiple word files to multiple pdf? tell this bro!

[@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

[@MIS_PRODUCTION_AAA]

Convert each pages into pdf