Thread: VBA to Embed Object
View Single Post
 
Old 03-10-2017, 12:27 PM
bilich bilich is offline Windows 10 Office 2013
Novice
  
Join Date: Mar 2017
Posts: 3
bilich is on a distinguished road
Default VBA to Embed Object
Hi,

I have a bit of code that works decent, but I would like to update to be cleaner. Right now, when you run the code it will open the dialog box for you to select a file. Once the PDF is selected, it embeds the image on the next page. When this happens it also opens up the PDF. Would there be a way to have the PDF automatically closed out when doing this?

Also, I would like to be able to create a target area for image to go to that I can change the size of and the PDF will adjust to the size of the target area. Is something like that possible?

Any help you can provide is greatly appreciated!

Code:
Option Explicit
Sub AddFileIcon()
    SendKeys "%F{TAB 4} {TAB 5}"
    Dialogs(wdDialogInsertObject).Show
End Sub


Thank you,
Reply With Quote