I had retrive data from database and I require to do more with the data. right now I need to put those data input a worksheet.
This is what I have down
private sub datatoexcel()
Dim excelo as object
Dim I as integer
set excelo = createobject("Excel.Sheet")
the problem is now I don't know how to input data into cell??do I use excelo.cell(x,y) = variable to input data or there is a eary way??and how do I save the the object into a xls file after I finish everything?