We help IT Professionals succeed at work.

Add data to an existing excel file??

RedRado03
RedRado03 asked
on
Medium Priority
260 Views
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?  
Comment
Watch Question

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.