PDA

View Full Version : Solved: Save Word File as PDF in 2007 using VBA



Solrac3030
01-28-2010, 11:32 AM
I need to save a word File in PDF using VBA and then set the prperties of the document back so that it keeps it's original name and the Save button will bring up the save dialog box. The save as PDF is not known to the user as this file will be placed elsewhere on the network. Any help will be appreciated. I am just not sure how to set the save to PDF format in VBA,

lucas
01-28-2010, 11:37 AM
I don't have 2007 but doesn't it have the capability to saveas pdf?

Solrac3030
01-28-2010, 11:45 AM
Yes it does, I need to do this using VBA as I do not want the user doing this process. The process should be invisible to the user.

lucas
01-28-2010, 11:59 AM
Did you try recording a macro and use that in document open procedure?

Solrac3030
01-28-2010, 12:26 PM
Yes but recording the macro and then doing a save as PDF did not show anything in the Code. Because of the dialog box it does not show up as part of code for the document. Thanks, but I figured out what the code is and got it working. Appreciate your help.

lucas
01-28-2010, 12:29 PM
Post it for others if you don't mind.