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.

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" <(E-Mail Removed)> wrote in message news:CA4E92A1-A3F1-4991-9E17-(E-Mail Removed)...
>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.