Consulting

Results 1 to 3 of 3

Thread: Import Photos and Captions Based on Excel Data

  1. #1

    Import Photos and Captions Based on Excel Data

    Full disclosure, I've never done any VBA coding within Word. My only experience has been VBA coding of mathematical process in Excel. Currently, what I'm trying to do is import photos with captions into a Word document. I currently have an Excel sheet that maps to the folder where the photos are stored and creates a list of the photo names in Column A. From there, I type a relevant caption into Column B. In Column C, I type in a numeric value of the order I want the photos to be in (i.e. 1-10).

    I'd like the end product to be a Word file with photos (maybe 2 per page if that's even something you can code) with the captions inserted below the images in the order specified in Column C of the Excel file. I've done some searching through the forums and it looks like there are some codes that may be applicable but they generally do not involve looking to Excel for some of the data. Any help would be appreciated even if you can just point me in the right direction.

    Thanks!

  2. #2
    See https://www.gmayor.com/photo_gallery_template.html This will do what you require.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  3. #3
    Looks like it's exactly what I need. Thanks for your help!

Posting Permissions

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