i need a vba code to copy a worksheet to a new excel workbook with the same
worksheet format as the original. Also the code should ask the user to
specify the file name.

thanks