I was programing in VBA for a couple of months but sometimes I need some feautures there are not integrated in VBA and I was thinking maybe to start to programming in VB.net and use the excel's cells throught VB.net ¿It is possible?
1 Answer
yes, you can. Here is a link to StackOverflow were someone is using VS2010 and excel. Also a link from microsoft.
-
2Correct. VBA is for code within a document, whereas VB.Net runs outside the document, and can manipluate it via the office interop COM libraries. Apr 9, 2013 at 14:49