[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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?  
0
RedRado03
Asked:
RedRado03
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now