Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Valued Contributor

export only active objects to powerpoint using macros


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

Tags (2)
1 Reply
Not applicable

Re: export only active objects to powerpoint using macros

,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


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

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