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.
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.
Thanks for reply. IS it possible to export the object of hidden sheets.
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.
Retrieving data ...