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
Printable View
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
??
Are you:
In excel...(all VBA?)
In VB Controling Excel?
In VB with Spreadsheet OLE?
with in excel using vb editor but i do have vb pro 6
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.
You can also Grab Excel if its currently open:
Dim Xls As Object
Set Xls = GetObject(,"excel.application")
Xls.Range("A1").Value = Text1.text
Thankyou sorry for later reply been working on something else
keep on coding !!!:D