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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator 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
jonathandienst
Partner - Champion III
Partner - Champion III

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
Creator III
Creator III
Author

Hi Jonathan,

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

jonathandienst
Partner - Champion III
Partner - Champion III

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