Copy Embedded OLE object from Access to Word

[Guest]

Hello,

For a custom billing application I would like to achieve the following:

1. User makes custom calculation in OLE embedded Excel worksheet on Access
Form
2. User clicks button to start Word mailmerge with information from Access,
including complete embedded worksheet

Quite a feat of Office integration! But how to achieve this? It is the
transfer of the OLE object which is difficult. It can be done using copy and
paste. But I do not know how to trigger a Copy action on the object in VBA.
Furthermore, this means whatever the user has on the clipboard is overwritten.

Any ideas anyone?

Kind regards,
Ries

 

[Guest]

object.SetFocus
DoCmd.RunCommand acCmdCopy

seems to work.. Too bad about the user's clipboard ;-)