Ernie,
Have you tried making a template?
That why the user can name it, the format will always be the same.

FloMM2

"ernie" wrote:

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