|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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:
Thanks in advance! |
#2
|
|||
|
|||
Am I blacklisted? I thought I'd get a reply by now.
|
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
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.
|
#5
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |