ShawnExcel
Member
I have maxed out my VBA knowledge and can't seem to get this to work.
Context:
I have an Excel Form that is filled out, and then populated answers in a word document. The word document has a bunch of pictures that need to be replaced every time we generate a new report.
The Problem:
I need to run a Macro that somehow replaces the placeholder photos with the correct photos. The correct photos will all have names like "Photo1" and will all be located in the same folder.
1) How can the macro identify the placeholder photos in order to replace them (do I even need placeholder photos, or should I use some other placeholder as a reference so the macro knows where to place the photos)
2) How can the Macro "change" or "replace" that placeholder with the a certain image based on the image path.
I know this is a 1/2 word, 1/2 excel question - if it helps I can have all the images linked from Excel into Word? Any thoughts are greatly appreciated.
Context:
I have an Excel Form that is filled out, and then populated answers in a word document. The word document has a bunch of pictures that need to be replaced every time we generate a new report.
The Problem:
I need to run a Macro that somehow replaces the placeholder photos with the correct photos. The correct photos will all have names like "Photo1" and will all be located in the same folder.
1) How can the macro identify the placeholder photos in order to replace them (do I even need placeholder photos, or should I use some other placeholder as a reference so the macro knows where to place the photos)
2) How can the Macro "change" or "replace" that placeholder with the a certain image based on the image path.
I know this is a 1/2 word, 1/2 excel question - if it helps I can have all the images linked from Excel into Word? Any thoughts are greatly appreciated.