hi,
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.
>
>
>>thank you for reply,
>>i try as under ,i get a message (there is alarge amount of information on clipboard. do you want to be able to paste this information into another program later....> i try YES and NO
>>I don't see any new excel sheet at my folder,