New WB not book

[aaronward]

is there anyway to creat a new workbook and instead of creating it with 'book1' it creates a WB with a suggested name?

 

[PolarBear]

If the user is going to enter the new file name, use a MsgBox to get the new name, and store it in a string (NewFileName makes sense...).

Then just do wb.SaveAs NewFileName.