Is there a way to invoke a macro from excel using ASPOSE?

I am currently working on a project where we are hoping to use ASPOSE to automate some process that was originally done through excel macros. The macro was originally invoked by a button click in the excel sheet. Now my question is, can we run this macro through ASPOSE? If yes, what's the syntax of calling the macro code from ASPOSE using VB .NET? If not, is there any alternatives to achieve this goal? Thanks.

Aspose.Cells doesn’t support to call macro code. You may have to convert it into .NET code.

Thanks. Two more questions:

1. I noticed that on the webpage for ASPOSE.cells, "Supports VBA " and "Supports macros" was listed in the advanced features. What exactly do they mean?

2. I read from one of your previous post that "VBA code can only run in excel". Then what if I invoke a macro upon file open event of an excel file? In that case, if I open this file through ASPOSE, will the macro automatically run and produce the result I want?

Thank you

1. Aspose.Cells can preserve macro and VBA in your template file and write it into output file.

2. Aspose.Cells won't run VBA/macro. It just preserves them in the output file. When you use MS Excel to open the created file, MS Excel will run it.

Is there any chance of this feature being ran in the future? The reason I ask is that we are using Aspose to create xls files based off templates and these templates have different vba code in them for each template (including future templates) that must be ran while creating the xls file.

Are there any workarounds to this so that I may be able to get a macro to run while creating a spreadsheet?

Hi,

Well, we have already considered these features and put them to our work list. Hopefully, it will be available in future.

Thank you.

I don't suppose you can give me a time frame on this can you? I have to make a decision soon on what direction to head with this.

After investigating more on VBA, we have to say that this feature cannot be supported.