Support to include macro from external excel file to final excel output

Aspose.Cells Product Family
1

Hello ,

Background: Our Product “IBM Engineering lifecyle optimization - Publishing” generates excel output.

Now we need a feature of including macro within the output excel doc. This we want to include by providing an input of another excel which contains the macro, and the ouput excel will contains this macro.

So can Aspose cells

  1. Read macro from another excel document
  2. write that macro to another document

Regards,
Zeeshan Khan

2

@Zeeshan_Noor_Khan,

By default, if you read an Excel file (that contains vba codes/macros) via Aspose.Cells APIs and you manipulate data or other elements and then resave the file with other name, the output file will retain your existing macros/vba codes. But if you need to copy vba codes/macros from one workbook to other workbook, see the document for your reference.