actually, i need to do both..But first, i try it to add data to sheet 2 within same work book.. i try both
VB Code:
  1. Set objSheet = objBook.Sheets.Item("Sheet2")
and also this way:
VB Code:
  1. Set objSheet = objBook.Sheets.Item(2)
both of this code not succesfull..