CODEWITHSUNDEEP
c#.netexcelvba
user4930777
user4930777

Reputation:

How to have C# connect to the excel API

Is it possible to connect to the same excel libraries that are used in VBA, but to instead use C# to be able to use all of the .Net framework features? I would like to recreate some automated VBA applications in C# at some point in the near future on the .Net framework to expand upon their capabilities and increase their speeds but I'm not sure how to do this.

Upvotes: 5

Views: 173

Answers (1)

John Smith
John Smith

Reputation: 7407

I believe you can reference the .dll file directly which is referenced by default when using VBA. It is called the "Microsoft excel object library", and you add it as a reference the same way you would do with any other namespace in C#

Here is a great reference to use http://www.codeproject.com/Articles/5123/Opening-and-Navigating-Excel-with-C

Upvotes: 1

Related Questions