Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 02-13-2020, 10:56 PM
henhelm henhelm is offline Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Windows 10 Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Office 2016
Novice
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet
 
Join Date: Jun 2019
Posts: 13
henhelm is on a distinguished road
Default

, So now that that's fixed, it is only populating one picture and one caption.
Reply With Quote
  #17  
Old 02-13-2020, 11:08 PM
macropod's Avatar
macropod macropod is offline Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Windows 7 64bit Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,900
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Assuming the data start on row 2, try the revised code.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #18  
Old 02-13-2020, 11:52 PM
henhelm henhelm is offline Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Windows 10 Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Office 2016
Novice
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet
 
Join Date: Jun 2019
Posts: 13
henhelm is on a distinguished road
Default

Yes, thank you!

One last request . Can you help me change the captions to read "Photograph X: Caption", in Times New Roman with size 10 font, and 5 spaces between the colon and caption?
Reply With Quote
  #19  
Old 02-14-2020, 12:04 AM
henhelm henhelm is offline Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Windows 10 Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Office 2016
Novice
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet
 
Join Date: Jun 2019
Posts: 13
henhelm is on a distinguished road
Default

Also, please let me know how to make a financial contribution. Thank you!
Reply With Quote
  #20  
Old 02-14-2020, 12:23 AM
macropod's Avatar
macropod macropod is offline Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Windows 7 64bit Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,900
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Quote:
Originally Posted by henhelm View Post
Can you help me change the captions to read "Photograph X: Caption", in Times New Roman with size 10 font, and 5 spaces between the colon and caption?
Change:
CaptionLabels.Add Name:="Picture"
to:
CaptionLabels.Add Name:="Photograph"
Change:
Label:="Picture"
to:
Label:="Photograph"
Insert:
Code:
  With .Styles("Caption")
    With .Font
      .Name = "Times New Roman"
      .Size = 10
    End With
    .ParagraphFormat.TabStops.Add Position:=CentimetersToPoints(2.5), Alignment:=wdAlignTabLeft
  End With
before:
'Add a 2-row by NumCols-column table to take the images

Note: Word doesn't work with spaces the way I expect you want. Using a tab-stop should give a comparable result.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions henhelm Word VBA 4 06-27-2019 08:49 PM
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Inserting multiple photos at a specific size Mr M Drawing and Graphics 2 06-20-2018 08:07 PM
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Excel Macro: Multiple Search and Post in Excel Sheet andxie Excel Programming 10 05-31-2018 05:21 PM
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Inserting and formatting photos in word 2013 tha_slughy Word VBA 5 07-13-2014 04:39 PM
Macro for Inserting Multiple Photos into Word but retrieving Captions from Excel Sheet Inserting / formatting multiple photos into Word doc. Jeremiahts Drawing and Graphics 1 03-23-2011 07:33 PM


All times are GMT -7. The time now is 01:36 PM.


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