Excel VBA to convert word file to pdf

[adekinteristi]

Hy all,

happy 2018

i have question about VBA code.

is it possible to convert word file to PDF using VBA excel?

in the attached file as seen bellow

Untitled.jpg

the word file path is where the word file location, PDF file path is where will PDF saved, and PDF file name is the name of converted PDF.

so converting, path location and the name of the PDF file is using PDF?

thanks in advance

[Logit]

.
Here are a few resources that will hopefully get you started in the right direction :

https://stackoverflow.com/questions/...to-pdf-convert

https://www.thespreadsheetguru.com/t...in-same-folder

https://sebnilsson.com/blog/microsof...-to-pdf-files/

http://www.msofficeforums.com/word-v...-into-pdf.html

[macropod]

Your screenshot suggests the PDFs will have the same names & extensions as the documents. Don't do that! At least your attached workbook has the correct extensions. Try:

Please Login or Register  to view this content.

[adekinteristi]

sorry, that's my fault, forget to change the extension of PDF file

i'd try your code, but error:

Please Login or Register  to view this content.

[adekinteristi]

it says that the word file is locked for editing. but i think i don't locked the file
do you know why it's locked?

[macropod]

OK, change that line to:

Please Login or Register  to view this content.

[macropod]

it says that the word file is locked for editing. but i think i don't locked the file
do you know why it's locked?

You probably have an orphaned Word session that still has a document open. Close Word, then use the Task Manager to kill all remaining Word sessions.

[adekinteristi]

still won't work

[macropod]

It does for me...

Check that your file paths & names are correct.

[buran]

The code is using early binding. Make sure you have set reference to MS Word Object Library in References. Otherwise wdFormatPDF is unknown to excel (i.e. that is constant from Word object model)
see https://support.microsoft.com/en-us/...-in-automation