I inserted an pre-formated spreadsheet into my VB 6 form, but I want to be able to write data to the spreadsheet for display and saving. How can I write data to my OLE inserted spreadsheet

I tried ActiveWorkbook.Sheets.Cell(A2).Value but that doesn't work. Can someone help me.

how do I call the sheet that I want to write to
Sheets1.sheets.cell(a2)?

I am not sure if I need to call Excel objects in to play. Need help.