Sounds messy to me, can you attach an example workbook with dummy data in? I can't see why you don't create the temp file, email it then delete it. Certainly you could rename it on creation.