Working between Office applications

[CJinMadison]

Good morning, all:

I am trying to craft some code that will take an existing MS PowerPoint presentation, and do the following:

Step 1: Save this PowerPoint presentation as a handout... which is an MS Word document.

Step 2: Take that MS Word document, and do a bunch of formatting to it.

So far, I have the code for Step 2. But, it is simply written to be run once the MS Word document has been created, and is open.

I am looking for guidance in crafting the code for Step 1.

I would (ultimately) like a one-button solution that will... take the PowerPoint file, save it as the Word file, and then do all that formatting/modification to it. And, be done.

Any assistance, guidance, advice on how to do that?

I appreciate any help.

CJinMadison

 

[SkipVought]

hi,

Please post VBA (code) question in forum707 for better results and responses, as this forum is directed toward user issues at the appliation level and not the programming level.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xwb]

Another option might be to post it to the vbscript forum. You can run vbscript from the command line to control both apps.

 

[zelgar]

Step 1 is already included in Powerpoint at least in the '07 version. If you hit the Office Button in the upper left corner, you'll get a list of commands. One of them is Publish which gives you the option to Create Houndouts in Microsoft Word. There's around 5 options on the layout of the slides depending on if you want notes/blank lines to the right of slides/below slides.

 

[CJinMadison]

Thank you. I have re-posted in VBScript forum.

And, Zelgar, my thanks for your interest. But, I am already aware that the command is available within MS PowerPoint to make this conversion.

What I am wanting to do is execute this process programmatically, so the user doesn't have to open MS PowerPoint at all. Just make it cleaner...

1) the user opens MS Word
2) the user runs macro XYZ
3) the macro prompts the user for the name of the MS PowerPoint file
4) the user provides the name
5) the code automatically
a) converts the PowerPoint file to an MS Word file, and
b) then performs the code I've already written to manipulate the new MS Word document.

Thx.

Cliff