spreadsheets again

[lainuk]

ive made a text box which when i click on a command buttton it will get the value in the textbox and put it in cells in a spreadsheet below....... i really need the whole code or at least some

[Static]

??

Are you:

In excel...(all VBA?)
In VB Controling Excel?
In VB with Spreadsheet OLE?

[lainuk]

with in excel using vb editor but i do have vb pro 6

[nswan]

this is using VB6

dim xl as new excel.application

xl.workbooks.open("c:\spreadsheet.xls")

xl.cells(1,1) = textbox1.text

xl.quit
set xl = nothing


you need to set the microsoft excel refererence as well first.

[Static]

You can also Grab Excel if its currently open:

Dim Xls As Object
Set Xls = GetObject(,"excel.application")
Xls.Range("A1").Value = Text1.text

[lainuk]

Thankyou sorry for later reply been working on something else
keep on coding !!!