Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro for copy objects

Hi guys,

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

Can you guys please help me with it?

Saurabh

19 Replies
venkatg6759
Creator III
Creator III

Sub CopyCC

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

End sub

Not applicable
Author

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
Creator III
Creator III

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

paste it in another sheet.

venkatg6759
Creator III
Creator III

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

Not applicable
Author

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
Creator III
Creator III

@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
Creator III
Creator III

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