Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 stonecold111
		
			stonecold111
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 Simon_Astakhov
		
			Simon_Astakhov
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
