Copying sheets into a new work book
 

I would like to make it an option for users of a program that I created in MS
Excel 2003 to save eight sheets and the data into a new workbook. I would
like to do this because there is sensitive information in the original
program and they will not be able to email a copy of that with the updated
material. The sheets that I want copied to email should not have any material
that cannot be seen. I would like the workbook to be named in this fashion if
possible: €œEmail Version <producerName€� on to the users desktop. If the
workbook is on the desktop, the user can move it or email it from there as
needed.

Copying sheets into a new work book
 

Hi Josh

Here is a code example to mail but you can remove the mail part and the delete part
http://www.rondebruin.nl/mail/folder1/mail3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Josh C" wrote in message ...
I would like to make it an option for users of a program that I created in MS
Excel 2003 to save eight sheets and the data into a new workbook. I would
like to do this because there is sensitive information in the original
program and they will not be able to email a copy of that with the updated
material. The sheets that I want copied to email should not have any material
that cannot be seen. I would like the workbook to be named in this fashion if
possible: €œEmail Version <producerName€� on to the users desktop. If the
workbook is on the desktop, the user can move it or email it from there as
needed.