coolere Version :-)
06.12.2013 13:53:37
Klaus
Hi,
Version 2 (nach der wirst du gleich eh fragen):
Modul:
Sub SendInfo(whatInfo As String)
'variablen an das send-Makro übergeben
Dim sText As String
Dim sTo As String
Dim sCC As String
Dim sSubject As String
sTo = "elvis.theking@firmenname.com" 'hier korrekte Mailadresse eintragen!
sCC = "" 'CC, falls gewünscht
sText = "In " & ActiveWorkbook.Name & " hat " & Environ("Username") & " am/um " & Format(Now, (" _
hh:mm dd.mmm.yyyy")) & " " & whatInfo
sSubject = "Datei wurde geändert: " & ActiveWorkbook.Name
Call SendSheetOutlook(sSubject, sTo, sCC, sText)
End Sub
Private Sub SendSheetOutlook(sSubject As String, sTo As String, sCC As String, sText As String)
Dim olApp As Object
Dim olOldBody As String
Set olApp = CreateObject("Outlook.Application")
Application.ScreenUpdating = False
With olApp.CreateItem(0)
.GetInspector.Display
olOldBody = .htmlBody
.To = sTo
.cc = sCC
.Subject = sSubject
.htmlBody = sText & olOldBody
.Send
End With
Application.ScreenUpdating = True
End Sub
Mappe:
Public OldValue As String
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns(1)) Is Nothing Then
Call SendInfo(Target.Address & " verändert von " & OldValue & " auf " & Target.Value & "!")
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
OldValue = ActiveCell.Value
End Sub
ThisWorkbook:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Call SendInfo("gespeichert")
End Sub
Das grenzt dann aber schon an verbotener Mitarbeiterüberwachung ;-)
Grüße,
Klaus M.vdT.