Add data to an existing excel file??

How do you add to an existing excel speadsheet??  Say the excel file exists with 2 columns and x amount of rows.  With a vb form you have your firstname in a label or textbox and your lastname in another.  When you hit an add button it adds the text to excel file in the next available row with the firstname in the first column and lastname in the second column.  Can this also be do without actually opening the file?  
RedRado03Asked:
Who is Participating?
 
hatem72Commented:
0
 
sbarrow1Commented:
If you save the spreadsheet as a comma separated file .cvs then you can append to it using file i/o.  If will still open the file but not use xcel to do it if that is what you are after.

Cheers

Stephen
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.