I've created a qvd document where in it there is a sheet made of several objects. User will select a 'Parameter' from the provided ListBox on the upper left corner of the sheet. So with each selected parameter, the objects' projected values will change to reflect the selection. Then there is another requirement to export those charts based on all the available parameters in the ListBox into PowerPoint. I wonder if there is a macro, say would automate clicking on the values in the ListBox one by one and on between one click to another, would export the objects on the sheet that is showing the values reflecting the selected parameter in the ListBox?
Thank you very much for your kind attention. I got bumped out several weeks already searching for any solutions. Attached is the screenshot of the document for your kind review. Any suggestions, code snippets are much appreciated. Thanks!
I've tried the example that you gave me and it works the same when exporting to PowerPoint though of course you need to change the code a little bit. I'll be sure to post the sample of my work sometime later.
NNprinting. (Www.vizubi.com) provides a PowerPoint template to author a ppt using both qlikview objects and rats expressions. They provide a button extension to call the template from a dashboard sheet too for 'on demand ' export. It works well ... If you want to avoid the overhead of coding.