views:

51

answers:

1

Is it possible to run existing excel macros in Spreadsheetgear?

A: 

SpreadsheetGear can open xls and xlsm workbooks with VBA macros, preserve the macros, and save the macros back to disk, but SpreadsheetGear cannot execute VBA code.

SpreadsheetGear does provide an API which is similar to Excel, so you can frequently move your VBA code to VB.NET or C#.

SpreadsheetGear also supports custom functions, but again, you must provide .NET implementations of them or they will return #NAME!

Joe Erickson