LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default sending the active worksheet and an additional new sheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a new Worksheet AFTER the existing (Active) sheet Ronnie Excel Worksheet Functions 1 January 12th 10 10:03 PM
Fill out worksheet and only print active sheet Trad Excel Worksheet Functions 0 November 21st 06 01:06 PM
Copy an additional row based on another sheet Mindie Excel Discussion (Misc queries) 5 October 19th 05 02:47 AM
Worksheet is no longer the active sheet Event Todd Huttenstine Excel Programming 3 May 21st 04 09:16 PM
Help sending active sheet to email list Kingtriotn Excel Programming 5 January 18th 04 10:43 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"