Copy excel sheet without formula to new excel sheet

how to build this??

use excel application scope

The Workbook Activities are better. No need for Excel Application Scope, the Workbook Read Range and Write Range are standalone. And more reliable.