Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-14-2015, 04:58 AM
gmayor's Avatar
gmayor gmayor is offline Vba Word multiple images at bookmarks Windows 7 64bit Vba Word multiple images at bookmarks Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The following will put the selected graphics at your bookmarks, four to a document.
Put all the code in the same new module
Code:
Option Explicit

Sub InsertImages()
'Graham Mayor
Const strFile As String = "C:\Path\ImageTemplate.docx"        'The template
Dim oBM As Bookmark
Dim oDoc As Document
Dim vImages As Variant
Dim i As Long
    vImages = Split(BrowseForFiles, Chr(124))
    On Error GoTo err_Handler
    For i = LBound(vImages) To UBound(vImages) Step 4
        Set oDoc = Documents.Add(strFile)
        ImageToBM "bm1", CStr(vImages(i))
        ImageToBM "bm2", CStr(vImages(i + 1))
        ImageToBM "bm3", CStr(vImages(i + 2))
        ImageToBM "bm4", CStr(vImages(i + 3))
    Next i
lbl_Exit:
    Exit Sub
err_Handler:
    GoTo lbl_Exit
End Sub

Private Function BrowseForFiles(Optional strTitle As String) As String
'Graham Mayor
'strTitle is the title of the dialog box
Dim fDialog As FileDialog
Dim i As Long
    On Error GoTo err_Handler
    Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
    With fDialog
        .Title = strTitle
        .AllowMultiSelect = True
        .Filters.Clear
        .Filters.Add "Image Files", "*.jpg,*.png,*.tif,*.bmp,*.gif"
        .InitialView = msoFileDialogViewList
        If .Show <> -1 Then GoTo err_Handler:
        BrowseForFiles = ""
        For i = 1 To fDialog.SelectedItems.Count
            BrowseForFiles = BrowseForFiles & fDialog.SelectedItems(i)
            If i < fDialog.SelectedItems.Count Then
                BrowseForFiles = BrowseForFiles & Chr(124)
            End If
        Next i
    End With
lbl_Exit:
    Exit Function
err_Handler:
    BrowseForFiles = vbNullString
    Resume lbl_Exit
End Function

Private Sub ImageToBM(strBMName As String, strValue As String)
'Graham Mayor
Dim oRng As Range
    With ActiveDocument
        On Error GoTo lbl_Exit
        Set oRng = .Bookmarks(strBMName).Range
        oRng.InlineShapes.AddPicture _
                Filename:=strValue, LinkToFile:=False, _
                SaveWithDocument:=True
        oRng.End = oRng.End + 2
        oRng.Bookmarks.Add strBMName
    End With
lbl_Exit:
    Set oRng = Nothing
    Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Combobox to multiple bookmarks scarda Word VBA 4 01-20-2015 10:48 PM
Vba Word multiple images at bookmarks Form updating Bookmarks - writes to the bookmarks multiple times PeterPlys Word VBA 13 01-14-2015 06:41 AM
Preview multiple images midjack Outlook 0 10-18-2014 08:35 AM
Vba Word multiple images at bookmarks VBA code to extract specific bookmarks from multiple word files Rattykins Word VBA 4 06-27-2012 10:02 PM
Vba Word multiple images at bookmarks Multiple Background Images in MS Word 07 Mark Drawing and Graphics 3 05-06-2009 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft