I did something with VBA at a time, but that's a while ago. I'm not good at it, plus in the new Office, MS has taken out the recorder, making it harder to learn or refresh your knowledge ...
I think, however, that it would probably be easier to create a macro that does both
- refreshes the ppt and
- sends it
than to have the macro triggered by your refreshing the ppt.
<=> I don't know how that QlikkView thing will react to that, try out if the Qlikview_elements in that ppt are also refreshed when you do that.
go through the below posts.
I mean a macro in PPT (in VBA, which is common to all Office applications). The order of execution would thus be
1) trigger macro
2) macro refreshes ppt_file -> QlikView_elements in ppt_file are refreshed, too
3) macro sends refreshed ppt_file via email
I think QlikView has some Sendmail functionality, but I think by default QlikView cannot create ppt files.