Macro to convert word into pdf from excel VBA

[jimraynor]

Hi,

starting with a excel file I would like to convert a specific file (.docx) in a folder, into a .pdf. I can write the path in the code. I would like to do this operation without opening the .docx file.

Thx for help

[Kenneth Hobson]

Please Login or Register  to view this content.

[macropod]

Alternatively:

Please Login or Register  to view this content.

Note that it's not possible to do as the OP asks without opening the file.

[jimraynor]

Hi,

I insert both the code in a module in excel but doesn't work. I select the code but when I try to execute the macro nothing happens. Where I wrong?

[macropod]

Both macros assume you're calling the MakeWordPDFFile sub from another macro or function. Mine assumes only that it's called with the path & name of the Word document (e.g. Call MakeWordPDFFile("some document path & name")); Ken's assumes it's called with the path & name of the Word document and the path & name of the pdf it's to be saved as. Since you said "I can write the path in the code", it's reasonable for us to expect you to know how to do that.

[jimraynor]

You're right! It's work! Thx to both.