ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you save each sheet in a workbook separately? (https://www.excelbanter.com/excel-worksheet-functions/238219-can-you-save-each-sheet-workbook-separately.html)

Angela

Can you save each sheet in a workbook separately?
 
I'm trying to make this easy, and we need to send worksheets through email,
and I don't want to have to re-do or copy and save each worksheet.

Thanks!

Bernard Liengme[_3_]

Can you save each sheet in a workbook separately?
 
I think Ron can help at
http://www.rondebruin.nl/sendmail.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Angela" wrote in message
...
I'm trying to make this easy, and we need to send worksheets through
email,
and I don't want to have to re-do or copy and save each worksheet.

Thanks!




Ron de Bruin

Can you save each sheet in a workbook separately?
 
For the Op

Yes i have code for this on my site

See also the mail templates from my site

If you have 2007 I have a new version (beta)
If you want to test that one let me know


"Bernard Liengme" schreef in bericht
...
I think Ron can help at
http://www.rondebruin.nl/sendmail.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Angela" wrote in message
...
I'm trying to make this easy, and we need to send worksheets through
email,
and I don't want to have to re-do or copy and save each worksheet.

Thanks!




__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com