1 Reply Latest reply: Oct 27, 2010 5:32 AM by HofbauerAn RSS

    Executing Macro when distributin PDF Report

    HofbauerAn

      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.