Creating image file from Word document failing

[pbassett]

This Excel VBA code used to work perfectly for over 100 Word documents displaying metrics that consist of several shapes, charts, etc.
The goal is to save the Word document as an image file since the monitor that displays the metrics don't support Word.
But now .PasteSpecial results in only the partial document remaining when the image file is created. I have NO idea how this happened.

With wdapp.Selection
    .WholeStory
    .Copy
    .PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, Placement:=wdInLine, DisplayAsIcon:=False
End With

 

[Yongle]

Intrigued by your code
- I have not seen this method used previously
- I gave it a go and it worked as expected
- I was unable to recreate your issue using Office 2016

This is what I did..
- new Word document created
- some shapes, a smart-shape, some text, an Excel Table and a chart inserted
- document saved and closed
- document opened via VBA (run from Excel)
- your code converted everything (excl header and footer) into a single image
- image could be manually saved in 5 different formats

Is the problem caused by something in the Word document ?
- I presume you are re-using documents and inserting updated metrics
- try re-creating ONE of the problem documents from scratch

Follow-up
1. Let me know how you get on
2. Purely for my enlightenment ...which code are you using to create the image files?

 

[Yongle]

A different method
- starting over may not appeal to you, but the method I use to create similar images is via PowerPoint
- design each slide to contain required shapes, charts, tables etc
- each slide is converted to a separate image file

To convert every slide in the active presentation to images...

Sub ConvertSlidesToImages()
    Const fPath = "c:\test\MetricImages"
    Const fName = "metric_"
    Dim slideNo As Integer

    With Application.ActivePresentation
        For slideNo = 1 To .Slides.Count
            .Slides(slideNo).Export fPath & "\" & fName & slideNo & ".jpg", "JPG"
        Next slideNo
    End With
End Sub