topic Re: Export to PPT in QlikView

Export to PPT

Tue, 10 Sep 2013 08:04:50 GMT

Hi Community,

I created button to run macro, it can export the chart to PPT when I test in module.

But it is not functioning when I clicked the button on dashboard. Anyone has solution?

Code:

Sub ppt

Dim myArray(9)

myArray(0) = "CH393"

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

For each item in myArray

Set PPSlide = objPresentation.Slides.Add(1,11)

ActiveDocument.GetSheetObject(item).CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

Thanks and best regards,

csy

Re: Export to PPT

Andrea_Ghirardello — Tue, 10 Sep 2013 09:07:16 GMT

Hi,

1. For each ... next is not supported. Use For count = 0 to ubound(MyArray)...next

2. you declared MyArray with 9 elements, you configured only the first ( MyArray(0) ), then you cycled through all elements....it's not correct.

See the Automation Reference Manual for "VB keywords and functions not supported by VBScript"

Re: Export to PPT

Wed, 11 Sep 2013 03:23:44 GMT

Hi Andrea,

Thanks for your guidance, I am new to VB actually. I tried to edit the code and run, seems like it is not working to paste the sheet object to power point. May I know where is going wrong?

Thanks and best regards,

Chanel

Re: Export to PPT

rajeshvaswani77 — Wed, 11 Sep 2013 04:15:56 GMT

Hi Chanel,

The most easiest way to do this is, go to last tab caption and select "Copy image to clipboard". You will get one icon on the chart on the top right side. The user has to just click this and then go to PPT and paste the chart. Macro would cause many dependencies, it may cease to work sometimes on AJAX client.

thanks,

Rajesh Vaswani

Re: Export to PPT

Wed, 11 Sep 2013 04:23:00 GMT

Hi Rajesh,

Really appreciated your reply, but actually what client requests is export the whole sheet to one slide of PPT, which I think is pretty hard, because sometimes the sheet is longer than actual resolution in image.

And we have many charts in one sheet and around 10 sheets on the dashboard, client might not like to copy paste the chart one by one for 50++ charts...

Thanks and best regards,

Chanel

Re: Export to PPT

rajeshvaswani77 — Wed, 11 Sep 2013 04:25:56 GMT

Please have a look at Reports Menu Item of QlikView Desktop. This functionality could be helpful to you. Truly speaking, have not used it myself.

thanks,

Rajesh Vaswani

Re: Export to PPT

er_mohit — Wed, 11 Sep 2013 04:30:37 GMT

Try this code

sub ppt

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True ' Create a presentation

Set PPPres = PPApp.Presentations.Add

Set PPSlide = PPPres.Slides.Add(1, 1)

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

PPSlide.Shapes.Paste

PPPres.SaveAs "E:\Qlikview\Prima\PPT\Presentation.ppt"

PPPres.Close

PPApp.Quit

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

msgbox " PPT MADE"

end sub

replace with your chart object id

and make sure in macro means ctrl+m

On Left side below

Request Module Security-->System access

Current local security-->System access

and on dashboard side

press ctrl+shift+m

and tick radio button Give system access to module script

hope it helps

Re: Export to PPT

Wed, 11 Sep 2013 06:08:19 GMT

Hi,

This is working when i tested in module, but it is not functioning when i tried to click on the button object.

May I know why?

Thanks and best regards,

Chanel

Re: Export to PPT

SunilChauhan — Wed, 11 Sep 2013 06:51:46 GMT

Hi,

use Control+Shift +M and select the first option

give system access to module script;

and try

hope this helps

Sunil

Re: Export to PPT

Wed, 11 Sep 2013 06:53:48 GMT

Hi Sunil,

I tried this step as it is mentioned in Mohit Shama's post but it doesn't work.

I am wondering what is happen to that button?

Thanks and best regards,

Chanel

Re: Export to PPT

Tue, 24 Sep 2013 02:58:36 GMT

Dear Community,

Anyone can figure out why my macro button can only work in module but not on dashboard?

Thanks and best regards,

Chanel

Re: Export to PPT

Andrea_Ghirardello — Tue, 24 Sep 2013 07:03:59 GMT

You should write

ActiveDocument.GetSheetObject(MyArray(count))

instead of

ActiveDocument.GetSheetObject(item)

Re: Export to PPT

Tue, 24 Sep 2013 07:57:40 GMT

Hi Andrea,

It is executable in module only, do you know why it is no response when i clicked the button on dashboard?

Thanks and best regards,

Chanel

Re: Export to PPT

preminqlik — Tue, 24 Sep 2013 10:05:02 GMT

if you have containers ,then macro fails to export from there container occurs,

so once remove all containers and try ..

Re: Export to PPT

Andrea_Ghirardello — Tue, 24 Sep 2013 10:21:39 GMT

1. which is the behaviour when you click the button?

2. try this:

a. save the qvw

b. close the qvw

c. open the qvw again and allow macro execution

d. click the button

3. did you add an action to the button (mouse dx\properties\actions tab\click on add button and select the "external" action type\choose the run macro action and write the correct macro name).

Re: Export to PPT

Tue, 24 Sep 2013 12:01:56 GMT

hi,

macros only work with the IE Plugin so you have to use Internet Explorer and install the IE Plugin.

Hope it helps.

regards,

Re: Export to PPT

Wed, 25 Sep 2013 01:46:41 GMT

Big hug to Andrea! I missed the last last step - Name the macro!

Best regards,

Chanel

Re: Export to PPT

Wed, 25 Sep 2013 02:47:23 GMT

Can you use VB code in the Personal Desktop edition of QlikView?

Re: Export to PPT

Wed, 25 Sep 2013 02:59:46 GMT

yea, it is working pretty good.

Re: Export to PPT

Fri, 20 Jun 2014 11:04:17 GMT

Do you know how run the macro to copy the whole sheet/selections to ppt, instead of just the chart