Hello
I ve been asked to look at what can be used for running a macro from within excel
I ve seen snippets of code on various forums but is there any library (open source preferably) that will help me with this in a robust manner??
Apache / Sourceforge dont have much !!
For running macros within Excel: VBA.
Then there are the Visual Studio Tools for Office which is mainly an Office extension point for use with .NET and therefore C#.
If you need to manipulate Excel files without having to run Excel, you may take a look at NativeExcel.
If you just want to get vba fucntion value at runtime,you can try SmartXLS for .net,it has a feature which allow you write custom add-in function to evaluate the vba fucntion(in the same function name) in Excel file.
If you're looking for a good, reliable library for Excel functionality, use Spire.XLS. It is much better, than NativeExcel.
I use ExcelDNA. From the Codeplex intro: "Excel-Dna is an independent project to integrate .NET into Excel. The primary target is the Excel user who currently writes VBA code for functions and macros, and would like to start using .NET."
Its quite good. I've written a bunch of UDFs using this framework.