is there a way to export just 1 worksheet of an entire workbook

[lizzie14]

I'm trying to attach an excel file to an email. I don't want to attach the
entire file, just one worksheet of the workbook. Is this possible without
saving a million different excel files?

 

[Paul B]

lizzie14, have a look at Ron's page here

http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003