PDA

View Full Version : Open Word document and re-save as PDF


garyb@se.rr.com
01-03-2014, 04:44 PM
I was wondering if anyone had a macro or means to open a MS-Word document via automation and save it as a PDF document from with in VBP.

Unfortunately Microsoft does not include any command line switches to perform this operation and obviously would have to be done via automation.

I would then like to include this process as a step in VBP (version 7.7a by the way).

Any help is appreciated :D

kinook
01-03-2014, 04:53 PM
https://www.google.com/search?q=vbscript+word+ExportAsFixedFormat

garyb@se.rr.com
01-03-2014, 05:10 PM
Thank you for the assist. Where should I put these scripts (Appears to be VBA) and how do I pass parameters to them. I created a step in my project ConvertWordToPDF, and pasted this script in but I dont see any way to pass it any parms. :)

kinook
01-03-2014, 05:29 PM
Typically, the dynamic value will be stored in a Visual Build macro (from a list in a loop, passed on the command-line, etc.), which you can reference in a Run Script step like so: %WORD_FILENAME%

http://www.kinook.com/VisBuildPro/Manual/runscript.htm

Or just put the filename in the code. You can put the function definition in project script code and call it from multiple Run Script steps.

http://www.kinook.com/VisBuildPro/Manual/scripteditor.htm