You can use SaveAs(0 method of a workbook.

...
oWorkbook.SaveAs(lcExcelFileName)
oExcel.Quit()

>I am doing some stuff like
>
>oExcel = createobject("excel.application")
>oWorkB = oExcel.workbooks.open(fname)
>oWorkS1 = Workbooks.worksheet[1]
>
>then I do row & cell manipulation
>.value = "whatever"
>
>Then at the bottom (of a do while) I Add a sheet
>oWorkS1 = oWorkB.Worksheets.Add( ,oWorks1)
>
>*At the bottom of my do while, What I would really like to do is somehow save the sheet I just created as an XLS
>or otherwise pass the sheet as a ".XLS" so that my email process can attach it to outgoing email *
>Is this possible? Thanks