Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to write a macro to copy a chart object to clipboard.
Can you guys please help me with it?
Saurabh
Sub CopyCC
ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard
End sub
CopyBitmapToClipBoard () copies chart object or the image of it?
because i need the chart object so that i can do paste in other sheet..
You can right click on sheet object and copy to clipboard and select object and
paste it in another sheet.
check in layout of that object if Allowcopy/clone is ticked.
Hi Venkat,
My requirement is to to do using Macros. Is there any way?
Saurabh
ActiveDocument.GetSheetObject("CH01").WriteXmlPropertiesFile("myobj.xml")
CreateObjectFromXmlPropertiesFile("myobj.xml")
-Rob
@RobWunderlich, I need create this object in the new sheet. You can help me ?
When on the new sheet, run the macro that executes:
CreateObjectFromXmlPropertiesFile("myobj.xml")
-Rob
Rob, but have this is erro :incompatible types 'CreateObjectFromXmlPropertiesFile'