Aug 19 2020 01:34 AM
Hi
I have following code that I want to change
I would like to add to the code that just page 1 of the sheet should be sent. Is there someone who can help?
Private Sub CommandButton1_Click()
Dim OlApp As Object
Dim NewMail As Object
Dim TempFilePath As String
Dim FileExt As String
Dim TempFileName As String
Dim FileFullPath As String
Dim FileFormat As Variant
Dim Wb1 As Workbook
Dim Wb2 As Workbook
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
Set Wb1 = ThisWorkbook
ActiveSheet.Copy
Set Wb2 = ActiveWorkbook
With Wb2
If Val(Application.Version) < 12 Then
FileExt = ".xls": FileFormat = -4143
Else
Select Case Wb1.FileFormat
Case 51: FileExt = ".xlsx": FileFormat = 51
Case 52:
If .HasVBProject Then
FileExt = ".xlsm": FileFormat = 52
Else
FileExt = ".xlsx": FileFormat = 51
End If
Case 56: FileExt = ".xls": FileFormat = 56
Case Else: FileExt = ".xlsb": FileFormat = 50
End Select
End If
End With
TempFilePath = Environ$("temp") & "\"
TempFileName = ActiveSheet.Name & "-" & Format(Now, "dd-mmm-yy h-mm-ss")
FileFullPath = TempFilePath & TempFileName & FileExt
Wb2.SaveAs FileFullPath, FileFormat:=FileFormat
Set OlApp = CreateObject("Outlook.Application")
Set NewMail = OlApp.CreateItem(0)
On Error Resume Next
With NewMail
.To = " receiver"
.CC = ""
.Subject = "Ident"
.Body = "Kan dere vennligst sende Ident"
.Attachments.Add FileFullPath
.Display
End With
On Error GoTo 0
Wb2.Close SaveChanges:=False
Kill FileFullPath
Set NewMail = Nothing
Set OlApp = Nothing
'Now set the application properties back to true
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
End Sub