Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sagarkharpude
Contributor III

Export hidden objects to PPT using macro

Hi Folks,

I want to export hidden objects to PPT by using macros. I have written the macro for export to ppt. But after hiding the objects i could not able to export the objects to ppt.

Can you please help me.

Thanks

3 Replies
MVP
MVP

Re: Export hidden objects to PPT using macro

I think the problem is QV does not re-calculate hidden objects. So if the object is never visible, it will not be generated and cannot be exported.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sagarkharpude
Contributor III

Re: Export hidden objects to PPT using macro

Hi Jonathan,

Thanks for reply. IS it possible to export the object of hidden sheets.

MVP
MVP

Re: Export hidden objects to PPT using macro

Same problem, I think. You may be able to make the object visible, wait for idle, export and then hide the object again in your script. You may be able to find such a script if you search the community.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein