<div>
If you save the spreadsheet as a comma separated file .cvs then you can append to it using file i/o. &nbsp;If will still open the file but not use xcel to do it if that is what you are after.<br />
<br />
Cheers<br />
<br />
Stephen<br />

</div>


<div>
<div class="content wysiwyg-content">
How do you add to an existing excel speadsheet?? &nbsp;Say the excel file exists with 2 columns and x amount of rows. &nbsp;With a vb form you have your firstname in a label or textbox and your lastname in another. &nbsp;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. &nbsp;Can this also be do without actually opening the file? &nbsp;
</div>
</div>


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?  

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


Add data to an existing excel file??

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,