MrExcel Publishing
Your One Stop for Excel Tips & Solutions

automating Microsoft Word

Posted by Melissa Rose on August 20, 2001 4:06 PM

I would like to know if this is possible, and if so, some guidelines on how to accomplish the following scenario.

Given a 10 page word document where each page contains a combination of text, table, and varying style formats.

I would like to create something, perhaps checkboxes in excel or something else to have 10 checkboxes that correspond to each of the 10 pages in Microsoft Word. If I check all 10 checkboxes, then it should save the all 10 pages of the Word document into a new Word document file for me to print. If I only check the first checkbox, the new Word document should only contain the first page of the given Word document.

Is there any way to do this using Microsoft Office 2000 products? If yes, which product is best to use with Microsoft Word? Or, is there a way to do this only using Microsoft Word?

Thank you so much for your help, I'm completely stumped!

Posted by Ian on August 21, 2001 12:08 AM

I don't know the code but why not use the check boxes in word?

should imagine it'll be new .doc copy/paste/save kinda thing


Posted by anno on August 21, 2001 1:15 AM

hi melissa
there is probably a way to do this with vba in excel but it would be less complicated to just use vba in word and leave excel out of it - the cross application connections work well enough most of the time(!) but I'm sure you could achieve an effective and certainly a simpler result in word - vba works fine with word too. it seems to me that most of what you want to do is in word anyway, so it's perhaps more about automating a process using vba rather than about excel. or there may be an even simpler way to do what you want in word without resorting to vba. without trying to sound too off-putting, you might like to try a forum like this that specialises in microsoft word. there are probably dozens but one i have used is at
good luck.

Posted by Melissa on August 21, 2001 9:12 AM

Thank you for that help link. I'll defininitely try that. As for putting checkboxes in Word, I didn't know you could do that. I'll have to try to figure out how to do that. Thanks so much for your suggestion! :)