Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stonecold111
Creator III
Creator III

create ppt macro is working on desktop but not in access point

Hi Qlikss,

I am using this macro for creating ppt ,which works fine in desktop but not in access point.

Document properties--> security-->  macro override settings.

system--> setup-->qlikview server--> secuity-->allow unsafe macro  exection on server.

i have made these settings . still it's not working in access point and ui am using test server.

what else changes do i need to make to work it in access point.

any suggestions???

Sub ExportPPT 

Set objPPT = CreateObject("PowerPoint.Application") 

objPPT.Visible = True 

Set objPresentation = objPPT.Presentations.add

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

ActiveDocument.GetSheetObject("CH02").CopyBitmapToClipboard 

PPSlide.Shapes.Paste 

PPSlide.Shapes(PPSlide.Shapes.Count).Top = 150 'This sets the top location of the image 

PPSlide.Shapes(PPSlide.Shapes.Count).Left = 15 'This sets the left location 

PPSlide.Shapes(PPSlide.Shapes.Count).Width = 240 

PPSlide.Shapes(PPSlide.Shapes.Count).Height = 250 

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

ActiveDocument.GetSheetObject("CH02").CopyBitmapToClipboard 

PPSlide.Shapes.Paste 

PPSlide.Shapes(PPSlide.Shapes.Count).Top = 150 'This sets the top location of the image 

PPSlide.Shapes(PPSlide.Shapes.Count).Left = 15 'This sets the left location 

PPSlide.Shapes(PPSlide.Shapes.Count).Width = 100 

PPSlide.Shapes(PPSlide.Shapes.Count).Height = 200 

Set PPSlide = Nothing 

Set PPPres = Nothing 

Set PPApp = Nothing 

End Sub 

Labels (3)
1 Reply
Simon_Astakhov
Partner - Contributor III
Partner - Contributor III

Hi.

Which client used? AJAX, IEPlugin or Desktop (open on Server)?

Is cliend setting OverrideModuleSecurity is set?

Check QVS-Security option "Allow Macro Execution on Server", document properties seems is correct when you can execute this macro in same document in Desktop.

Plus, check PowerPoint on server and client side.