VB text box to excel Cell

How can I transfer data from a text box into a specific named file, worksheet and cell of an excel spreadsheet.

Excel file name "Account.xls"
Worksheet 1
Cell (C,10)

Text box named "acc_text"

I need to export the data to the spreadsheet from my VB application.
Who is Participating?
WigmansConnect With a Mentor Commented:

Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open ("Account.xls" )
xlApp.ActiveCell.FormulaR1C1 = acc_text.Text

Good luck
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.