MrExcel Publishing
Your One Stop for Excel Tips & Solutions

emailing a single worksheet from a workbook


Posted by Tim Drake on December 19, 2000 7:32 AM


We have developed a nice timesheet application. It would be nice if we could e-mail this weeks timesheet without creating addition files (temp. files would be fine).

Thanks
Tim


Posted by David on December 19, 2000 11:41 PM


I have done this and if you copy the sheet to a new workbook. send the workbook and then close it without saving it

you do this by saying
activeworkbook.saved=true
activeworkbook.close