Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have written a macro to export charts to ppt.
its working fine in QlikView Document, but not working in Access Point.
Its giving error "ActiveX Component Cant create object: 'PowerPoint.Application' error in IE Plugin
i tried checking that select 'Allow System Access' Option also, but also macro not working.
so what could be the problem?
Arpan,
Then in that case for debugging the code.
Just add the below code in your code
msgbox 1
and check in every line by adding this msgbox.
so that you can find out, on which line you are getting an error.
I used the following:
ActiveDocument.GetSheetObject("TX01").CopyBitmapToClipboard
msgbox 1
When I run the code it opens a blank presentation that't it and doesn't display the message box. Also it highlights the ActiveDocument....code.
In the PowerPoint presentation itself, check to see if any objects pasted as blank white objects, then check "Keep Source Formatting" in the object properties. Sometimes this will help objects render in Power Point when the formatting is altered by PP.
I have been ablet o get the above code to run without a hitch in my environment. Make sure to
hit Ctrl + Shift + M in the application and grant System Access, or Ctrl + M and grant System Access under both drop downs.
Hi,
Your export to PPT is working fine in IE plugin???
and if yes, can you please give the macro to me...
Thanks alot.
Hey everyone !
I get the same error "ActiveX component can't create object: 'Powerpoint.Application'" when I use a macro.
From what I've read, Powerpoint has to be installed on the same server that the one which has the licence i'm leasing, is that right ?
Because, I've installed powerpoint on the server where I developped some application. The licence I use is rent from another server.
Thank you for your answer