Is there any api for executing a macro code on an excel? I don't want to use office interop and I don't want to recode usin开发者_StackOverflow中文版g aspose, I have lot of existing macros I just want to know if there's an api that can do that.
Are you looking to do it in .NET? There are programs for that. Like XLW, Managed XLL, Excel-DNA, Add-in Express, VSTO, etc.
To run a macro, you must create an environment in which the macro can run. To create such an environment you need to automate Excel. You can do this in an Excel add-in or in a standlone application in .NET or in Delphi, VB6, VC++ or other language. After you instantiate the Excel.Application object, you need to call the method it provides - RunMacro.
精彩评论