I have code set up to insert text into a blank word document from an excel workbook based upon a client code and image names. The entries act as temporary titles to images that will be produced for a design for a client. They are entered 1 per line with one line between each and always follow the same format ie CLIENT01_IMAGE1, CLIENT01_IMAGE2 etc. At a later stage I manually add text beneath the titles as descriptions of the images.
I now want to produce code within the workbook that will find a line of text and replace it with an image file.
This will serve as a document which will be given to the client and I would also like to have it sent to Wordpress as a ready made blog article.
The code I have so far calls up the correct document but fails to do anything else:
Most of this is copy and pasted and cobbled together from other codes. Any help would be greatly appreciated.
Nicky
Bookmarks