Simulate Excel automation

Aspose.Cells Product Family
1
Attilio Moregola v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
Hi i'm evaluating aspose component to manage excel files without MS Excel in programming way.
This is what I need to do ( now my program do this function with COM excel automation) .
1) open excel file
2) set values in some cells
3) call a custom public VBA function called "MyFunction" ( this funcion is inside the VBA code of a sheet). The function execute VBA code.
4) close the file
Can someone, please, give me a suggestion if this is possible with aspose ?
If it is possible can you post an example?

Thanks
Attilio
2

Hi Attilio,

Thanks for considering Aspose.

You scenario looks pretty simple except for vba code involvement (point 3). Well, I 'm afraid Aspose.Cells does not support to manipulate or otherwise execute vba codes currently. Although, if an excel file is loaded / saved by the component, the vba / macro codes will be preserved and saved with the file.

Thank you.