I have a spreadsheet that takes various data and converts into a Word Document.
The word document is set-up as a template and embedded into Excel.
When the VBA code runs, it opens the embedded word document and, by referencing various bookmarks, populates the document.
Is there anyway to insert a bitmap at a particular bookmark? I'm trying something along the lines of
wrdDoc.Bookmarks("Logo").Shapes.AddPicture (Sheets("config").Shapes("Hampshire"))
but it says Method or Data member not found.
An example of the code I have for inserting the text is:
wrdDoc.Bookmarks("P2Address1").Range.Text = Worksheets(PD).Cells(4, E)
This works fine for all the text elements I need to import, but I also need to import a bitmap file, embedded in excel. I can't just add it to the template itself, as the bitmap to be used depends on certain criteria filled out in the spreadsheet.
Any help would be appreciated.
The word document is set-up as a template and embedded into Excel.
When the VBA code runs, it opens the embedded word document and, by referencing various bookmarks, populates the document.
Is there anyway to insert a bitmap at a particular bookmark? I'm trying something along the lines of
wrdDoc.Bookmarks("Logo").Shapes.AddPicture (Sheets("config").Shapes("Hampshire"))
but it says Method or Data member not found.
An example of the code I have for inserting the text is:
wrdDoc.Bookmarks("P2Address1").Range.Text = Worksheets(PD).Cells(4, E)
This works fine for all the text elements I need to import, but I also need to import a bitmap file, embedded in excel. I can't just add it to the template itself, as the bitmap to be used depends on certain criteria filled out in the spreadsheet.
Any help would be appreciated.
