oExcel.ActiveWorkbook.SaveAs(lcNewXlsName)

>thank youn for reply,
>sorry, not clear saveas() .
>pls. can explain more.
>
>or where i can use it at the code.
>
>thanks
>
>>Use SaveAs() method to specify full file name for the Excel file.