Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
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!
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
Ian
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 http://www.helptalk.net/officeapps/.
good luck.
Melissa