if you want to do it from vba then you would add a line after theworkbooks.add or change the next line toActiveworkbook.saveas FileName:="abc"