Connecting VB with Excel

[Monochron]

Originally Posted by logank013

What is the difference between using Visual Basic Express like I use and Visual Basic for Applications? Or are we talking about the same Visual Basic?

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.