Add data to an existing excel file??

Posted on 2006-03-22
Last Modified: 2012-05-05
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?  
Question by:RedRado03
    LVL 6

    Accepted Solution

    LVL 1

    Expert Comment

    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.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
    I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now