Printing Word and excel documents via excel vba

C

crossy75

I have a document that has some Excel and some word content i would
like to use excel vba to print both a page from word and then a page
from excel. I know how to select and open the word document, however i
cant find any code to print page X from word.
basically i need to:

print page 1 of c:\xx\document1.doc
print page1 of sheet1 of c:\yy\excelwkbk1.xls
print page 2 of c:\xx\document1.doc
print page2 of sheet1 of c:\yy\excelwkbk1.xls


and so on it will require moving between word and excel - the excel
bit i get, but getting back to excel from word, and printing out in
word is slightly more complicated.


many thanks


Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Problem with printing a word document containing a table 0
Integrating information from Word to Excel (not mail merge) 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Page numbering with Merged Document and IF statements 1
Word Margins - Frustration 0
VBA - exporting serial letters to single documents 0
Embedded Excel into Word with Tables 0

Top