|
Re: Connecting VB with Excel
Quote:
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
__________________
Cyber Blue Season 2015
IN Indy District Chairman's Award Winner | IN Kokomo District Event Winner (With 135 and 3865)
IN Purdue District Event Winner (With 1024 and 2197) | IN District Championship Winner (With 1024 and 292)
WORLDS:
Archimedes Rank 3 After Quals. | Alliance #3 Captain
Archimedes Division Semi-Finalist (With 503,188, and 836)
Scouting is life. Excel is friend, not foe.
|