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: 
Not applicable

Executing Macro when distributin PDF Report

Hello,

I wrote a macro in my QV document, which selects values from my document.
I also set up a Document Event Trigger (OnPostReload), which executes the macro, when the document will be reloaded.

The Problem is, that I want to execute the macro, when I start my task to send the PDF Report from the document.
I enabled reload for the distribution task, but nothing happens.

Is there a possible way, to execute the macro when executing the PDF distribution task via Enterprise Management Console?

Here's my macro, maybe it helps:

Month_now = Month(now())
'Timestamp_now = Month(now

sub auswahlpdf:
ActiveDocument.ReloadEx 2,1
ActiveDocument.Fields("Timestamp").Select "1 FC Target"
ActiveDocument.Fields("Timestamp").ToggleSelect "actual"
'ActiveDocument.Fields("Reporting Month").ToggleSelect "Month_now"
ActiveDocument.Fields("Reporting Month").ToggleSelect "Month_Now"
end sub

Thanks in advance.

1 Reply
Not applicable
Author

Anybody?

I really need help with this.

Thanks!