Can you save each sheet in a workbook separately?

A

Angela

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!
 
R

Ron de Bruin

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 said:
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






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

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...


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

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save worksheets to different files 3
printing sheet names 2
Copying each worksheet in a new workbook 1
Workbook Printing Page Format 3
Can not copy a worksheet 2
How can I add the same data to every worksheet in a workbook all . 1
Lookup cell value using list of worksheet names 5
how to merge worksheets in the same workbook 3

Top