topic Re: Macro for copy objects in QlikView

Macro for copy objects

Mon, 16 Jun 2014 18:31:57 GMT

Hi guys,

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

Can you guys please help me with it?

Saurabh

Re: Macro for copy objects

venkatg6759 — Mon, 16 Jun 2014 18:37:22 GMT

Sub CopyCC

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

End sub

Re: Macro for copy objects

Mon, 16 Jun 2014 19:02:17 GMT

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

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

Re: Macro for copy objects

venkatg6759 — Mon, 16 Jun 2014 19:09:05 GMT

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

paste it in another sheet.

Re: Macro for copy objects

venkatg6759 — Mon, 16 Jun 2014 19:13:57 GMT

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

Re: Macro for copy objects

Mon, 16 Jun 2014 21:24:35 GMT

Hi Venkat,

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

Saurabh

Re: Macro for copy objects

rwunderlich — Tue, 17 Jun 2014 05:16:12 GMT

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

CreateObjectFromXmlPropertiesFile("myobj.xml")

-Rob

Re: Macro for copy objects

maiconmello — Fri, 15 Jan 2016 12:52:29 GMT

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

Re: Macro for copy objects

rwunderlich — Fri, 15 Jan 2016 21:50:35 GMT

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

CreateObjectFromXmlPropertiesFile("myobj.xml")

-Rob

Re: Macro for copy objects

maiconmello — Mon, 18 Jan 2016 10:59:30 GMT

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

Re: Macro for copy objects

beck_bakytbek — Mon, 18 Jan 2016 11:06:21 GMT

Try this:

Sub ScreenShot

ActiveDocument.ActivateSheet ("YourSheet" like SH12).CopyBitmapToClipboard

end Sub

hope that helps

Re: Macro for copy objects

maiconmello — Mon, 18 Jan 2016 11:16:19 GMT

I need copy this obj and pasting in the sheet, for this user is modify.

thank you !

Re: Macro for copy objects

beck_bakytbek — Mon, 18 Jan 2016 11:37:56 GMT

Hi Maicon.

can you explain me your Situation, i have some ideas, but i dont't understand your Business case

Beck

Re: Macro for copy objects

maiconmello — Mon, 18 Jan 2016 11:52:35 GMT

hi beck,

I need create a copy of the object.

why copy the object ?

For the user, is the possibility alter this propriety, with subtotal.

This is propriety is not enable when acess, only when create the new object.

Re: Macro for copy objects

beck_bakytbek — Mon, 18 Jan 2016 12:08:41 GMT

Do you mean "is not enable when acess": Access Point?

Re: Macro for copy objects

beck_bakytbek — Mon, 18 Jan 2016 12:12:20 GMT

Hi Maicon

in this blog you will find the solution for your Problem: qlikblog.at

if you dont find the solution, let me know, and we wll try together to find the solution.

Beck

Re: Macro for copy objects

rwunderlich — Tue, 19 Jan 2016 04:46:54 GMT

Can you upload a sample qvw that demonstrates the problem?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Macro for copy objects

HirisH_V7 — Tue, 19 Jan 2016 06:43:36 GMT

Hi,

Go to -> Tools -> Edit Module ->

Copy Paste this Code:

sub CopyObject

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

end sub

Then, Create a button-> Actions-> External->Run Macro -> CopyObject

There you should change CH01 as per your requirement to respective object ID.
You should also change left down in module settings->current local security and requested module security -> allow system access

By Clicking on the buttton Copy to clipboard done and then open your word document and paste it.

Hope this helps your requirement ,

PFA,

Hirish

Re: Macro for copy objects

maiconmello — Tue, 19 Jan 2016 10:49:47 GMT

Hi Rob, i send you my model for test.

Re: Macro for copy objects

rwunderlich — Tue, 19 Jan 2016 17:49:43 GMT

I'm sorry, I left off part of the code. CreateObjectFromXmlPropertiesFile is a member of Sheetobject, so the code has to be:

ActiveDocument.ActiveSheet.CreateObjectFromXmlPropertiesFile("CH01.xml")

I tested this in QV11 and it works, In QV12, which I see you are using, the macro hangs and I'm not sure why.

-Rob