Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to send the active worksheet plus an additional worksheet that I
would like to name. I want to name the new worksheet "Main". Here is the code I have that allows me to send the active sheet. What do I add in there to allow me to also add in a blank named worksheet? Private Sub Send1_Click() Dim strDate As String ActiveSheet.Copy strDate = Format(Date, "dd-mm-yy") & " " & Format(Time, "h-mm-ss") ActiveWorkbook.SaveAs "NewEmployeeData.xls" ActiveWorkbook.SendMail "", _ "Employee Attendance Data" ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName ActiveWorkbook.Close False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert a new Worksheet AFTER the existing (Active) sheet | Excel Worksheet Functions | |||
Fill out worksheet and only print active sheet | Excel Worksheet Functions | |||
Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
Worksheet is no longer the active sheet Event | Excel Programming | |||
Help sending active sheet to email list | Excel Programming |