Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

export only active objects to powerpoint using macros

Hi,

i am exporing objects to powerpoint using VBScript.

i am specifying all the object names in the macro and i need to check which object is active.

then after checking the active objects, i need to export only those active objects to powerpoint.

so how i can do this

Labels (1)
1 Reply
Not applicable

,IsActive seems to be what you need. The following is an example of how to use it from the api guide:

rem ** minimize all active sheet objects on active sheet **

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

for i=lbound(objs) to ubound(objs)

    if objs(i).IsActive then objs(i).Minimize

next