vba to save bound ole object - word automation 1

[Pampers]

Hi everyone,
I'm trying to do some word automation through vba. Here is what it does so far: create a new worddocument, add a template to it, save the new document with a unique name (number) on the hard disk. So far so good.

Now I want this document to be saved - linked - in an bound ole object which is on my form. How can I do that with vba??

Pampers
Just let it go...

 

[VicRauch]

I found this link and it looks like it will do the trick you are looking for:

http://www.ehow.com/how_12373_insert-picture-graph.html

The code you are looking for is at the bottom of this link.
HTH
Vic

 

[Pampers]

That is great VicRauch!
I even got the code working, although I have to have a look again (tomorrow) what exactly is happening. Here is the code I used.

With Me.frmContactLetterSub0.Form.[Letter]
.Enabled = True
.Locked = False
' Specify what kind of object can appear in the field.
.OLETypeAllowed = acOLELinked
' Specify the file to be linked.
.SourceDoc = "C:\My Files\Peters files\" & strFileName & ".doc"
' Create the linked object.
.Action = acOLECreateLink
End With

Tnx a lot, and a star of course.

Pampers
Just let it go...