Consulting

Results 1 to 2 of 2

Thread: Macro to add photos into columns - need to remove "Picture" reference

  1. #1

    Macro to add photos into columns - need to remove "Picture" reference

    Hi there,

    I came across this macro in a locked thread on here that allows you to add multiple pictures into a document (i.e. employee photo book), each photo with the file name underneath it, and it's working great for my purposes. However, I'm very new to macros and need to make a small change. When I run the macro, it inserts the words "Picture 1" before the file name. I would prefer it enter the name of the file and not "Picture 1" etc. before it (and I wish to keep the label under the picture as it is now).

    Does anyone know how to modify this macro? Here it is:

    Sub AddPics()
    Application.ScreenUpdating = False
    Dim i As Long, j As Long, c As Long, r As Long, NumCols As Long
    Dim oTbl As Table, TblWdth As Single, StrTxt As String, RwHght As Single
    On Error GoTo ErrExit
    NumCols = CLng(InputBox("How Many Columns per Row?"))
    RwHght = CSng(InputBox("What row height for the pictures, in inches (e.g. 1.5)?"))
    On Error GoTo 0
    'Select and insert the Pics
    With Application.FileDialog(msoFileDialogFilePicker)
    .Title = "Select image files and click OK"
    .Filters.Add "Images", "*.gif; *.jpg; *.jpeg; *.bmp; *.tif; *.png"
    .FilterIndex = 2
    If .Show = -1 Then
    'Add a 2-row by NumCols-column table to take the images
    Set oTbl = Selection.Tables.Add(Range:=Selection.Range, NumRows:=2, NumColumns:=NumCols)
    With ActiveDocument.PageSetup
    TblWdth = .PageWidth - .LeftMargin - .RightMargin - .Gutter
    End With
    With oTbl
    .AutoFitBehavior (wdAutoFitFixed)
    .Columns.Width = TblWdth / NumCols
    End With
    CaptionLabels.Add Name:="Picture"
    For i = 1 To .SelectedItems.Count Step NumCols
    r = ((i - 1) / NumCols + 1) * 2 - 1
    'Format the rows
    Call FormatRows(oTbl, r, RwHght)
    For c = 1 To NumCols
    j = j + 1
    'Insert the Picture
    ActiveDocument.InlineShapes.AddPicture _
    FileName:=.SelectedItems(j), LinkToFile:=False, _
    SaveWithDocument:=True, Range:=oTbl.Cell(r, c).Range
    'Get the Image name for the Caption
    StrTxt = Split(.SelectedItems(j), "")(UBound(Split(.SelectedItems(j), "")))
    StrTxt = ": " & Split(StrTxt, ".")(0)
    'Insert the Caption on the row below the picture
    With oTbl.Cell(r + 1, c).Range
    .InsertBefore vbCr
    .Characters.First.InsertCaption _
    Label:="Picture", Title:=StrTxt, _
    Position:=wdCaptionPositionBelow, ExcludeLabel:=False
    .Characters.First = vbNullString
    .Characters.Last.Previous = vbNullString
    End With
    'Exit when we're done
    If j = .SelectedItems.Count Then Exit For
    Next
    'Add extra rows as needed
    If j < .SelectedItems.Count Then
    oTbl.Rows.Add
    oTbl.Rows.Add
    End If
    Next
    Else
    End If
    End With
    ErrExit:
    Application.ScreenUpdating = True
    End Sub
    '
    Sub FormatRows(oTbl As Table, x As Long, Hght As Single)
    With oTbl
    With .Rows(x)
    .Height = InchesToPoints(Hght)
    .HeightRule = wdRowHeightExactly
    .Range.Style = "Normal"
    End With
    With .Rows(x + 1)
    .Height = CentimetersToPoints(0.5)
    .HeightRule = wdRowHeightExactly
    .Range.Style = "Caption"
    End With
    End With
    End Sub

  2. #2
    Rather than re-invent the wheel - see http://www.gmayor.com/photo_gallery_template.html
    Graham Mayor - MS MVP (Word)
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •