Macro for copy objects

[#1]

Hi guys,

I need to write a macro to copy a chart object to clipboard.

Can you guys please help me with it?

Saurabh

[venkatg6759]

Sub CopyCC

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

End sub

[#3]

CopyBitmapToClipBoard () copies chart object or the image of it?

because i need the chart object so that i can do paste in other sheet..

[venkatg6759]

You can right click on sheet object and copy to clipboard and select object and

paste it in another sheet.

[venkatg6759]

check in layout of that object if Allowcopy/clone is ticked.

[#6]

Hi Venkat,

My requirement is to to do using Macros. Is there any way?

Saurabh

[rwunderlich]

ActiveDocument.GetSheetObject("CH01").WriteXmlPropertiesFile("myobj.xml")

CreateObjectFromXmlPropertiesFile("myobj.xml")

-Rob

[maiconmello]

@RobWunderlich, I need create this object in the new sheet. You can help me ?

[rwunderlich]

When on the new sheet, run the macro that executes:

CreateObjectFromXmlPropertiesFile("myobj.xml")

-Rob

[maiconmello]

Rob, but have this is erro  :incompatible types 'CreateObjectFromXmlPropertiesFile'