How to convert all word files stored in the folder to PDF automatically?

Hi friends,

I want to convert all the word files to PDF store in the folder ‘OUTPUT’ store on ‘C’ drive. I have posted the thread on excel programming forum. Please see it and suggest me a concrete solution at the earliest. It is very urgent for me.

http://www.excelforum.com/excel-prog...ml#post4228940

Any help will be highly appreciated.

Thanking you in anticipation.

It's not clear from your post whether the files are already in the Output folder, or somewhere else. The following macro lets you choose any source folder:

Please Login or Register  to view this content.

Hi Paul,

Thank you.

I’m getting run-time error 438 object doesn’t support this property or method.

All the word files are already stored in the ‘output’ folder.
After opening the folder I want to convert all the word files in the folder to pdf one by one. If possible delete the word files after creating pdf files.

Hope this will help you to amend the code properly.

Thank you.

On what code line are you getting the error message, and what Word version are you using?

Hi Paul,
I’m getting error on the following line.

Please Login or Register  to view this content.

I’m using m. s. office word 2007.
Steps:
First click the macro
Dialog to select the word files to convert pdf
after converting word to pdf
Delete word file

Final output will be the pdf files in the output folder in place of word files. In this case there are 5 word files in the ‘output’ folder, so there will be 5 pdf files in the ‘output’ folder and all the 5 word files will be deleted.

Thank you.

The SaveAs2 method wasn't introduced til Office 2010. You may be able to achieve the same result using SaveAs instead.

Hi Paul,

I removed 2 from SaveAs2 and now getting run-time error 4198 command fail.

Thank you.

Does your "C:\Output\" folder exist? Do you have write permissions to it?

Hi Paul,

Good morning!

Now I change the folder path and recorded the macro which is working fine for first ‘A’ file but I want to convert all the files in the folder ‘OUTPUT’ to PDF.
However there are few amendmenttts are require as follows:

After opening the folder I want to convert all the files in the folder to pdf one by one automatically.
I don’t want any alerts to replace the existing file. It should automatically replace while saving automatically.
I don’t want to choose the file name of pdf file. It should be automatically.

I think after this amendments the program will work fine positively.

Please Login or Register  to view this content.

Sorry for trouble.

Thank you and have a nice day.

The code I provided in post #2 is all you should need - aside from changing SaveAs2 to SaveAs. That said, I see from post #9 you're actually using a different folder to the one you said you were using in post #1. You can't expect the code to work properly if you provide the wrong information...

In the code I provided in post #2, you could change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

As for the other code you posted in post #9, that uses a 3rd-party PDF driver, apparently named "doPDF 8". I have no experience with that product, no idea of whether it's even programmable vis-à-vis the filenames & overwriting, and I'm not going to invest any time in something that isn't necessary to get the job done.

Hi Paul,

Please don’t mind. Due to a technical problem the problem was occurring. So I change the path. Now the technical problem is solved by the computer engineer successfully.

Excellent! The program is working fine.

I by heart appreciate you for the same.

Only last question:
At present we have to choose the folder to create pdf files. Is it possible to make an ‘OUTPUT’ folder as a default folder and skip the choose folder dialog?
If it’s not possible then leave it. I will manually choose it.

Please let me know then I will mark the thread solved today.

Thank you for your kind assistance.

Try:

Please Login or Register  to view this content.

Hi Paul,

Excellent! Perfect as per requirement.

Thank you for sparing a lot of time to solve my problem.

Thank you and have a nice day.

Hi Paul,

The code is working fine but I’m facing a file name problem today as follows:

If the file name of word file is ‘Mrs. Fisher Sally.docx’ then after converting it to pdf change to ‘Mrs.pdf’. Because of this problem I’m unable to attach the pdf file to the mail as attachment. Without matching the file name it’s not possible to attach the file as attachment.

I don’t want to change the original file name. Please suggest me a solution.

Sorry for trouble.

Thanking you.