Have Geek Brain

VBA-enabled Spreadsheet Component

I am looking for a .NET component that can also execute VBA contained in Excel files.

I found Tables to be very nice to manipulate and allow the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, they don't work.

So besides Excel itself, are there any other components that can do VBA?

+2


a source to share


1 answer


You can directly execute service macros from .NET.

For example: vb.net



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


a source






More articles:


All Articles