WHEN i TRIED THIS CODE
VB Code:
  1. Set xl = CreateObject("Excel.Application")
  2. Set xlBook = xl.Workbooks.Open(App.Path & "\book1.xls")
  3.  Set xlSheet = xlBook.Worksheets.Add

IT ALWAYS START FROM WORKSHEET 4 ,BECAUSE BY DEFAULT, EXCEL OPEN 3 BLANK WORKSHEET ONSTART, HOW DO I CHANGE THE CODE SO THAT i COULD SAVE FROM WORK SHEET 1 WITHOUT LEAVING FIRST THREE WORKSHEETS BLANK?


THANKS