Work-around for exporting sheet contents and removing code
 

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

Work-around for exporting sheet contents and removing code
 

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

Work-around for exporting sheet contents and removing code
 

Thanks Ron

Work-around for exporting sheet contents and removing code
 

Now I have a question about the file sizes--my workbook is about 2.7
megs, and when I export 2 sheets using the add-in or sample code, the
exported file remains about 2 megs. When the contents of the sheets
are selected manually, the size is considerably less. There is not
much difference between the amount of data in the manual selection vs.
the entire 2 sheets--just formatting. I've removed formatting in both
codes... Any ideas?

Thanks