Calculate Macro before opening OR saving workbook

Aspose.Cells Product Family
1

Hi,

We are working on some reports using Aspose.Cell .

Our excel template have some macro code in it . When we save this excel file without opening in ExcelWindow I am not able to evaluate my macro code.

Actually I am converting this excel to PDF , this converted PDF file doesn't have any macro code evaluated.

Is there any utility with which I can evaluate macro before opening excel in pdf .

Something similar to workbook.CalculateFormula();

2

Hi,

Well, I am afraid, Aspose.Cells does not support to run/evaluate macro code in excel files, it will only preserve the macros in the template file and save/save as the file with it. You need to open the excel file in MS Excel to run the macro code.


Sorry for any inconvenience.