How do you Write Data to an exel worksheets

[CVL1975]

Maybe someone can help me with this. I have an excel worksheet template call MyExcelTemplate, it has 3 worksheets(Sheet1,sheet2,sheet3)and I want to write data to sheet1,sheet2,sheet3 from Visual Basic.Anyones can help me with this?.
I am truly appreciated.
Thanks,
CVL

 

[xlbo]

What do you mean "write data" - do you want to fill in cells with set data or formulae. Will the data change or will it stay the same. Need more info if you want examples Rgds
~Geoff~

 

[dsi]

Do a search for "Excel.Application" (without the quotes) in this forum. You will get hundreds of samples for this.

 

[ETID]

sub write_data()

sheets("sheet1&quot.range("a1&quot="vba code wrote this"

end sub

 

[kylua]

easier to use:

sheets(x).range("a1&quot="vba code wrote this"

Where x is the number of the sheet.

Or create an object representing the cell:

set currentcell = worksheets(sheetnumber).cells(x,y)
currentcell.value = "vba code wrote this"

This makes for neater code when looping thru columns or rows.