Move OLE Object from Access table to a Word Document

[sneuberg]

We need to replicate an Access report we have in Microsoft Word. The report has a fixed, small image in the header and so we embedded it in the report (it is not in and external file). To put this image in the Word document the only way we’ve come up with is shown in the code below.

Dim apWord As Word.Application
Dim doc As Word.Document
Set apWord = CreateObject("Word.application")
doc.Shapes.AddPicture "G:\Images\Sinful Banner.bmp", False, True, 0, 0, 540, 42



Which requires an external image file. We really would like to avoid this. We could make a template Word document, but that too would be an external file. We know how to put this image in a table as an OLE object, but can’t find any way to get it from the table into the Word document. Can anyone tell us if this is possible and better yet how to do it?

[June7]

AFAIK, you found the only method available. Even if image is saved in table, it must be saved out as external file. Code can accomplish that and then delete the external file after embedded in the Word document.

[orange]

cross posted http://www.access-programmers.co.uk/...d.php?t=279327