Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Do any one have macros to export objects from multiple sheets to powerpoint?
i see macros for only activesheet of qlikview document
Have you managed to find answer to your question?
I have been trying to play with different way to achieve but I can not find the right way.
One path lead to put all objects from all sheets in array and then send all to ppt but I can not find a way to achieve this.
i have some examples how to import to excel.if you want i give you some examples
Beck
Please share if it takes all objects from all sheets - maybe we can find solution for ppt
Hi Siva and Robert,
try this:
Sub PrintScreen()
ActiveDocument.ActivateSheet("yourSheet").CopyBitmapToClipboard.
End Sub
of course you can try to implent this expression on other objects/sheets
i hope, that helps
Beck