Could you show me an example where you click a button, it a number from a text box and puts it into to column A and the next available row.

VB Code:
  1. Dim objExcel As New Excel.Application

  2.  
  3.         objExcel.Visible = True

  4.  
  5.         objExcel.Workbooks.Add()

  6.  
  7.         objExcel.Range("A1").Select()

  8.         objExcel.ActiveCell.FormulaR1C1 = "75"

  9.         objExcel.Range("B1").Select()

  10.         objExcel.ActiveCell.FormulaR1C1 = "125"

  11.         objExcel.Range("C1").Select()

  12.         objExcel.ActiveCell.FormulaR1C1 = "255"

  13.         objExcel.Range("D1").Select()

  14.         objExcel.ActiveCell.FormulaR1C1 = "295"

  15.  
  16.        

  17.         objExcel = Nothing

I have leant ho to do this with a book I have, but what I want to do is open an existing excel file and add to it. It would be a great help if you can give me a very simple example.

Sam