CODEWITHSUNDEEP
.netexcelvbaspreadsheetspreadsheetgear
Renaud Bompuis
Renaud Bompuis

Reputation: 16786

Spreadsheet component with VBA support

I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files.

I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work.

So, apart from Excel itself, are there any other components that can execute VBA?

Upvotes: 2

Views: 1593

Answers (1)

Konstant
Konstant

Reputation: 2199

You can directly execute office macros from .NET

Eg: vb.net

 objExcel = New Excel.Application
 objExcel.Workbooks.Open(FileName:="c:\test.xls", ReadOnly:=True)
 objExcel.Run("test.xls!test.test")

Upvotes: 1

Related Questions