Skip to Content
avatar image
Former Member

Report Distribution and Macros

Hi Gurus,

Is it possible to trigger a macro during report distribution? If yes, is there an API for worksheet generation or is there anyway we can call worksheet generation?

Regards,

David

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 20, 2016 at 05:46 AM

    You can simulate worksheet generation by simple worksheet copy and setting page axis :)

    During worksheet distribution you can try AFTER_WORKBOOK_OPEN or BEFORE_REFRESH

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 06:06 AM

    Hi David,

    While distributing the report, the report is Refreshed first and then Distributed. so as Vadim also suggested you can have a macro BEFORE or AFTER_REFRESH as per the need. There is no API for worksheet generation.

    JP

    Add comment
    10|10000 characters needed characters exceeded