topic Re: Clone and Paste Object in QlikView

Clone and Paste Object

khan_imran — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Is it possible to clone/copy the object through macro and paste it in a New sheet?

Regards,

Imran Khan

Re: Clone and Paste Object

Anil_Babu_Samineni — Tue, 27 Dec 2016 02:30:36 GMT

Macros are not good at all, In fact, i would love to copy paste simple. even if you want by using Macro then you may use this

Sub 244456

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard ' Copy Data to clip board and object too

End sub

Re: Clone and Paste Object

ramasaisaksoft — Tue, 27 Dec 2016 06:38:18 GMT

Hi Imran,

Instead of clone/Paste the objects from one sheet to another you can do easily by copy (ctrl+c) and paste (Ctrl +V)

just press Ctrl + and select your wishing objects ,at last ctrl + c and go to next sheet where ever you want to paste Ctrl + V.

Re: Clone and Paste Object

khan_imran — Tue, 27 Dec 2016 10:31:22 GMT

My requirement is, I have 10 objects in one sheet and want to copy all with current selection in new sheet.

Regards,

Imran Khan

Re: Clone and Paste Object

ramasaisaksoft — Tue, 27 Dec 2016 10:39:57 GMT

Yes, imran those will come from one sheet to another sheet by using Ctrl + c and Ctrl + V the only thing is you need that related data for those coping objects in script if that is new application sheet

else

if it is in the same application sheet then automatically will come.