adobe pro to save word document (excel macro)

[ogerwolf]

Hello All,

I have an uncommon situation where I fill out a word form using excel marco (IT disabled word macos...). To follow up on the existent code I already have, I would like to be able to save the newly created word document into pdf. I like very much the adobe pro plug in and wondered if its possible to write a macro that will save my word document into pdf using the plug in.

Can someone help me with that, I dont even know where to start!

Thank you for your help

 

[Macropod]

If macro functionality has been installed for Excel, they have to be installed for Word - you CANNOT install VBA for one Office application and not for another. At most, one can change the macro security settings in the Trust Centre for a given application. Presumably, then, you can also change those settings. Regardless, you cannot save a Word document to PDF without automating Word but, since you're already doing that, saving to PDF is a trivial exercise. See, for example:
• Send Mailmerge Output to Individual Files; or
• Split Merged Output to Separate Documents,
in the Mailmerge Tips and Tricks thread at:
Mailmerge Tips & Tricks
or:
Word Mailmerge Tips & Tricks | Windows Secrets Lounge
IMHO it's rather pointless trying to control macro access the way your IT dept is doing - you're already circumventing it...

 

[ogerwolf]

word library hasn't been disable for excel. you just cant run macros inside MS word. I know how to save a word to pdf, my question is how to do it using adobe pro plug in I have.

thx

 

[Macropod]

Why would you do with Adobe when Word's own Save options can save to PDF? Using Adobe means automating that in addition to automating Word (which you're already doing). And, if you're thinking of using the Adobe 'print driver', AFAIK that can't be automated to save to a specified file/folder.