Hi Friends!!

   I've excel programe. In the Bold expression i want to use my defined object for "worksheets" can someone tell me how can i do that.


source is here:

   Private Sub Form_Load()
    Set ea = CreateObject("Excel.Application")
    Set wb = ea.workbooks.Add
    Set sht = wb.worksheets.Add

    Set shts = wb.worksheets

    ea.Visible = True

    sht.cells(1, 2) = "deepak"

    Set a = ea.ActiveWorkbook

    a.worksheets(2).Select

    'a.shts(2).Select

    End
End Sub


DPK..

__________________
DPK..