ole chart copy to clip

[jtkjames]

just wondering - anyone know the VBA function for copying an ole chart to clipboard?

various places suggest the command oleobject1.copy, but that doesn't appear in my ver of access (2002)

thanks

[jtkjames]

anyone????

[Rawb]

Try using the following:

MyOLEObject.Action acOLECopy

Where MyOLEObject is, obviously, your OLE Object.

[jtkjames]

thanks rawb.

i got error message invalid use of property from the above code as is but i put an "=" in there (prob a typo) and it worked just fine!

thanks again! ive spent ages looking for this.

[Rawb]

Not a typo per se. . .

I just didn't know how to use it myself!