-
My problem is
I want to enter the values from the textbox to the already existing xlbook say "C:\STOCK.XLS"
How to add the following code in the xlbook.
Xlsheet.cells(2,1)=text1.text
Private Sub Form_Load()
Set xlBook = GetObject("C:\STOCK.xls")
' Display Microsoft Excel and the Worksheet
' window.
xlBook.Application.Visible = True
xlBook.Windows(1).Visible = True
End Sub
-
This should do it
To enter a value (Text1.text) into
Column 'A'
Row '8'
Worksheet '1'
use the following
xlBook.Worksheets(1).Range("C8").value = Text1.text
Does this work?
Samwise Galenorn
[email protected]
