Print an Embedded Word Doc

  • Thread starter Thread starter michael.haight
  • Start date Start date
M

michael.haight

I have a workbook which contains multiple worksheets - each of which
has an embedded (not linked) Word document attached. I am attempting
to add a button on the very first sheet, which would print out ALL the
worksheets as well as the embedded Word documents.

However, all I've managed to do so far is print all the worksheets -
I'm having trouble getting the VBS code right for printing the
embedded Word documents.

Help?!

-Mike
 
Try this

for i =1 to ActiveSheet.OLEObjects.Count
ActiveSheet.OLEObjects(i).Activate
ActiveSheet.OLEObjects(i).Object.Application.PrintOut
next i


Faisal...
 

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

Printing multiple embedded Word Documents 7
embedded Word document 1
Print out embedded Word object 2
Excel Disallow movement of embedded PDF 2
Print Multi-Page Word Object in Excel 3
Select Embedded Documents 3
Word document reporting 3
embedded Excel sheets in Word documents 2

Back
Top