Connecting VB with Excel

[logank013]

Originally Posted by Monochron

If you are willing to jump to VBA, it could be a great tool for what you are looking to do. On the other hand, if you are looking to stretch your legs a bit with regular VB, I whole heatedly recommend EPPlus.

In your VB program you would have your Save button event read in all the text box values, update your EPPlus ExcelWorksheet object, then call the ExcelWorksheet.Save() function to write it to disk. You can even load the column names from the Excel file directly into your program by importing the file and just accessing the specific cells.

Here are some good examples:
http://www.jimmycollins.org/blog/?p=547
And I can send you my own example if you like.

Just out of curiousity, how different is the language from VB to VBA