This is a small part of a larger project that extracts data from a lis
to populate a form. Then it copies the form to a new sheet in a ne
workbook. I then want it to save the new workbook as the worksheet nam
in a directory that I have already choosen. It then goes back an
clears the form for the next use. And I then wish it to email the ne
workbook to three people with the subject being the file name.

Soooo if you can help with some of this let me know. I have most of i
working but I don't know how to get the save as sheet name to work.

Lin

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com