3

Is it possible to run existing excel macros in Spreadsheetgear?

naeron84
  • 2,955
  • 3
  • 30
  • 37
  • I've been searching for the web for this feature but no luck so far. I'm about to give up. I think this question will never be answered. – naeron84 Jun 30 '10 at 14:14

1 Answers1

4

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
  • 7,077
  • 1
  • 31
  • 31
  • Hi Joe. I'm glad I found this answer, but it is almost five years old now. Is this still the case? I'm expecting nothing has changed based on the product history I found [here](http://www.spreadsheetgear.com/downloads/whatsnew.aspx), but I thought I'd check. [Roadmap?](http://www.spreadsheetgear.com/products/roadmap.aspx) ;) Thank you! – Chris W. Rea May 02 '15 at 18:24
  • @Joe Erickson. As today are macros supported on SpreadsheetGear 2017? – CREM Jun 28 '19 at 19:52