Hi Arnold

Install my mail add-in, you have a option to delete the VBA in there
http://www.rondebruin.nl/mail/add-in.htm

don't want to have to manually reference VBA Extensibility and set
the trust access to visual basic project on different computers.

No other way, my code check this setting


How is it possible to create a unique name for the wbook (if Book1 or
Book2 or TodaysDate.xls is already present) and make this efficient?

My code examples use the date/time in the file name



--

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


"Arnold" wrote in message oups.com...
Hi Everybody,
I'm trying to copy some contents of two sheets into a new workbook to
be saved on the user's desktop and attached to an email. Ron's
send mail codes (http://www.rondebruin.nl/sendmail.htm) work great, but
I must get rid of all code behind the sheets in the new wbook. I have
also used Chip's code at http://www.cpearson.com/excel/vbe.htm, but I
don't want to have to manually reference VBA Extensibility and set
the trust access to visual basic project on different computers.

Is there a way around this in Excel XP through code?

OrI've created a macro to simply copy the content from the active
wbook, create a new wbook, paste and format as needed, etc.-but
cannot figure out how to name the new wbook and save it to the user's
desktop.

How is it possible to create a unique name for the wbook (if Book1 or
Book2 or TodaysDate.xls is already present) and make this efficient?

Thanks,
Eric