Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2019, 09:36 AM
henhelm henhelm is offline Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Windows 10 Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Office 2016
Novice
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions
 
Join Date: Jun 2019
Posts: 6
henhelm is on a distinguished road
Default Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions

I do not have any experience with Macros and need help.



Based on the attached, I need the macro to do the following:
  • Insert the "Text" from the spreadsheet as a paragraph into Word (at a specified location).
  • Locate photos from their shared file location based on the "Image #'s" (file name) in the spread sheet, and insert them into the Word document (at a specified location)
  • Insert respective "Captions" from the excel file with a preceding "Photo #:". For example, "Photo 1: Outside at the park", "Photo 2: Dogs at the park", etc.

Thanks in advance!
Attached Images
File Type: png Macro.PNG (10.8 KB, 21 views)
Reply With Quote
  #2  
Old 06-26-2019, 08:37 PM
henhelm henhelm is offline Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Windows 10 Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Office 2016
Novice
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions
 
Join Date: Jun 2019
Posts: 6
henhelm is on a distinguished road
Default

Am I blacklisted? I thought I'd get a reply by now.
Reply With Quote
  #3  
Old 06-27-2019, 02:07 AM
gmayor's Avatar
gmayor gmayor is offline Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Windows 10 Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
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 of
Default

As your requirement is vague and you seem to expect someone to program this for you it is not really a surprise that you haven't had a reply.

If you modify your worksheet in line with the description at https://www.gmayor.com/photo_gallery_template.html that might work for you - otherwise it seems that what you are describing is mail merge and that requires a particular syntax for the graphics merge - see https://www.gmayor.com/mail_merge_graphics.htm and https://www.gmayor.com/mail_merge_graphics_addin.htm
__________________
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
  #4  
Old 06-27-2019, 05:51 AM
henhelm henhelm is offline Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Windows 10 Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Office 2016
Novice
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions
 
Join Date: Jun 2019
Posts: 6
henhelm is on a distinguished road
Default

No, I just don't have experience in VBA and was looking for guidance, not a free code. Not sure why I gave that impression. I'm also new to the forum and still need to get acclimated to the culture that has been developed here. Thanks for the information you provided.
Reply With Quote
  #5  
Old 06-27-2019, 08:49 PM
Guessed's Avatar
Guessed Guessed is offline Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Windows 10 Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Rearrange your input data into consecutive cells starting in Cell A1. Leaving empty columns makes life so much harder.

Then explore mail merges before attempting a vba method.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
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 Need macro to fill the values in msword based on the excel sheet info ganesang Word VBA 50 08-29-2018 12:53 AM
Spreadsheet info got changed to Chart mparegian Excel 1 08-12-2015 10:36 AM
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions Input data in Excel and get info from Access zkibz Excel Programming 1 08-14-2014 05:17 PM
Info from excel spreadsheet to Power point anyquist Office 0 01-31-2011 12:29 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:14 AM.


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