Suggestions To Do the following:

[Gary]

I have embed OLE object in a table. My using the .Action = acOLECopy
command, I was able to copy the OLE objects and paste it into power point
(with verb = -2).

I now have an issue to updated the activated OLE object before pasting it
into power point. The reason, is that I am using the event document on open
to make my OLE application visible or invisible. During the activation time,
it will check my Access Global value and select the right VBA code to control
it being visible or not.

I was think of the following:

1) On open of the OLE Object, I will have VBA Code change the visible
properties of certain objects, select all and copy and paste the clip board
into power point.

2) I need to set the verb property of the bound object. I was using
acOLEVerbOpen which opens the OLE object in a separate application. Is there
a different one to use??? Openning a new windows does slow down the
processing.

3) The value that control the OLE object being visible or invisible was a
variable I declare as Global in Access. Depending on this value during the
Pasting of the object, It controls which object is visible for me to copy and
paste into power point.
I don't believe this is power point question.


I would appreciate any and all suggestions for an approach to this problem.


Thanks,

Gary