CODEWITHSUNDEEP
.netspreadsheetgear
naeron84
naeron84

Reputation: 3025

Spreadsheetgear run macro?

Is it possible to run existing excel macros in Spreadsheetgear?

Upvotes: 3

Views: 3939

Answers (1)

Joe Erickson
Joe Erickson

Reputation: 7217

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!

Upvotes: 4

Related Questions