how to copy an active excel sheet and save it into a new workbook using vbs script : Im trying to copy an excel sheet that includes formulas and paste it into a new excel workbook as values and retaining the format using vbs script.

Im currently doing it but instead of copying i'm saving it as a CSV. so is only saving the first page but it looses the format. 