PDA

View Full Version : Excel VBA: resizing a pasted image in word using excel VBA



baralus
05-10-2018, 11:50 AM
I have this code that creates a word document and takes a screenshot and paste it inside. Now what I want to know is how can i resize the image inside word document because the screenshot is always big that two images won't fit in a single page.

Sub Testing()
Dim wrd As Word.Application


Set wrd = Word.Application


With wrd
.Visible = True
.Activate
.Documents.Add
Call PrintScreen
.Selection.Paste
End With

End Sub