title: How to to add VB Excel Script in Excel Generated Jasper Report?
body: <p>Current Excel Report is created using Jasper Server / Jasper Report 3.8. </p>
  
  <p>In my case , I would like to create Pivot Excel automatically using Excel(Since Jasper Report Crosstab is not sufficient for my client requirement), so i have an idea to add VB Script that will create Pivot Table when the generated jasper report is opened for first time.</p>
  
  <p>I have created the VBA script However I couldn`t find a way to integrate the VBA with Jasper Report (generated) so that when I generated the Report, the VBA is also included in the Report. </p>
  
  <p>Could anyone tell me how to to add VB Excel Script in Excel Generated Jasper Report?</p>
  
  <p><strong>Added Constraint:</strong></p>
  
  <ul>
  <li>List item</li>
  </ul>
  
  <p>The Data Source (Excel File Containing Data) is protected</p>