-
Excel VBA: resizing a pasted image in word using excel VBA
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules