Good afternoon, I am creating a workbook that consists of three sheets that
interact with each to produce a report. I am trying to separate a specific
sheet, i.e. the report, that can be saved separately as an xls file and the
sheet singly sent as an email attachment. Any thoughts? Thanks for you time
and consideratin in this matter.
Hi Herren''s
If you install my SendMail add-in you can mail one sheet very easily
www.rondebruin.nl/mail/add-in.htm
Or right click on the sheet tab and choose quot;Move or Copyquot; to a new workbook--
Regards Ron de Bruin
www.rondebruin.nlquot;Herren''squot; gt; wrote in message ...
gt; Good afternoon, I am creating a workbook that consists of three sheets that
gt; interact with each to produce a report. I am trying to separate a specific
gt; sheet, i.e. the report, that can be saved separately as an xls file and the
gt; sheet singly sent as an email attachment. Any thoughts? Thanks for you time
gt; and consideratin in this matter.
You can find a macro Example here
www.rondebruin.nl/sendmail.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;Ron de Bruinquot; gt; wrote in message ...
gt; Hi Herren''s
gt;
gt; If you install my SendMail add-in you can mail one sheet very easily
gt; www.rondebruin.nl/mail/add-in.htm
gt;
gt; Or right click on the sheet tab and choose quot;Move or Copyquot; to a new workbook
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Herren''squot; gt; wrote in message ...
gt;gt; Good afternoon, I am creating a workbook that consists of three sheets that
gt;gt; interact with each to produce a report. I am trying to separate a specific
gt;gt; sheet, i.e. the report, that can be saved separately as an xls file and the
gt;gt; sheet singly sent as an email attachment. Any thoughts? Thanks for you time
gt;gt; and consideratin in this matter.
gt;
gt;
- Jul 16 Mon 2007 20:38
Saving a sheet as a separate file
close
全站熱搜
留言列表
發表留言