i only wish to export one of the worksheets only to another excel file.

it seems i can only export the whole workbook and delete other worksheets.

i try to use Worksheets("ABC").Delete but there is popup for yes or no
after.

how can i make it better? Thanks a lot.

tony