G
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
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