Hallo,
ich denke, dass das für so manchen von Euch von großem Interesse ist
Dieser Button trägt alle Spiele der Fussball WM2006 in Euren Notes-Kalender ein.
Button code:
(declarations):
Click:
Code
Sub Click(Source As Button) Set session = New NotesSession Dim boxtitel As String boxtitel = "Spielplan Fussball WM 2006" Dim ms As String, mf As String ' Text Server, Maildatei Dim mst As String, msg As String ' für Fehlermeldung If Not session.international.IsDateDMY Then Beep Beep Messagebox "Die Funktion wird nur ausgeführt, wenn das Datumsformat des Systems ""tag.monat.jahr"" ist. " & Chr(10) & Chr(10) &_ "Das Format kann ggf. in den Systemeinstellungen geändert werden (... Regional Options --> Germany ...).", 16 , "Abbruch: " & Boxtitel Exit Sub End If mail=Evaluate("@MailDbName") If mail(1) = "" Then Beep Messagebox "Sie haben keine Maildatenbank in Ihrem aktuellen Location-Document spezifiziert!", 48, boxtitel Exit Sub End If ms = mail(0) mf = mail(1) Set db = session.GetDatabase (ms,mf) If ms = "" Then mst = "loacl" Else Dim sn As New NotesName(ms) mst = sn.common End If msg = "Die Maildatenbank konnte nicht geöffnet werden (" & mst & " : " & mf &_ "). Überprüfen Sie die Eintragungen in Ihrem aktuellen Location-Document." If db Is Nothing Then Beep Messagebox msg , 48, boxtitel Exit Sub End If If Not(db.isopen) Then Beep Messagebox msg , 48, boxtitel Exit Sub End If Call addgame(" 09.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 1 / Gruppe A : Deutschland - Costa Rica ",""," München ") Call addgame(" 09.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 2 / Gruppe A : Polen - Ecuador ",""," Gelsenkirchen ") Call addgame(" 10.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 3 / Gruppe B : England - Paraguay ",""," Frankfurt ") Call addgame(" 10.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 4 / Gruppe B : Trinidad&T. - Schweden ",""," Dortmund ") Call addgame(" 10.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 5 / Gruppe C : Argentinien - Elfenbeinküste ",""," Hamburg ") Call addgame(" 11.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 6 / Gruppe C : Serbien&M. - Niederlande ",""," Leipzig ") Call addgame(" 11.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 7 / Gruppe D : Mexiko - Iran ",""," Nürnberg ") Call addgame(" 11.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 8 / Gruppe D : Angola - Portugal ",""," Köln ") Call addgame(" 12.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 9 / Gruppe E : Italien - Ghana ",""," Hannover ") Call addgame(" 12.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 10 / Gruppe E : USA - Tschechien ",""," Gelsenkirchen ") Call addgame(" 13.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 11 / Gruppe F : Brasilien - Kroatien ",""," Berlin ") Call addgame(" 12.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 12 / Gruppe F : Australien - Japan ",""," Kaiserslautern ") Call addgame(" 13.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 13 / Gruppe G : Frankreich - Schweiz ",""," Stuttgart ") Call addgame(" 13.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 14 / Gruppe G : Südkorea - Togo ",""," Frankfurt ") Call addgame(" 14.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 15 / Gruppe H : Spanien - Ukraine ",""," Leipzig ") Call addgame(" 14.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 16 / Gruppe H : Tunesien - Saudi-Arabien ",""," München ") Call addgame(" 14.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 17 / Gruppe A : Deutschland - Polen ",""," Dortmund ") Call addgame(" 15.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 18 / Gruppe A : Ecuador - Costa Rica ",""," Hamburg ") Call addgame(" 15.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 19 / Gruppe B : England - Trinidad&T. ",""," Nürnberg ") Call addgame(" 15.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 20 / Gruppe B : Schweden - Paraguay ",""," Berlin ") Call addgame(" 16.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 21 / Gruppe C : Argentinien - Serbien&M. ",""," Gelsenkirchen ") Call addgame(" 16.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 22 / Gruppe C : Niederlande - Elfenbeinküste ",""," Stuttgart ") Call addgame(" 16.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 23 / Gruppe D : Mexiko - Angola ",""," Hannover ") Call addgame(" 17.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 24 / Gruppe D : Portugal - Iran ",""," Frankfurt ") Call addgame(" 17.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 25 / Gruppe E : Italien - USA ",""," Kaiserslautern ") Call addgame(" 17.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 26 / Gruppe E : Tschechien - Ghana ",""," Köln ") Call addgame(" 18.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 27 / Gruppe F : Brasilien - Australien ",""," München ") Call addgame(" 18.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 28 / Gruppe F : Japan - Kroatien ",""," Nürnberg ") Call addgame(" 18.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 29 / Gruppe G : Frankreich - Südkorea ",""," Leipzig ") Call addgame(" 19.06.2006 "," 15:00:00 CEDT "," 16:45:00 CEDT "," Spiel 30 / Gruppe G : Togo - Schweiz ",""," Dortmund ") Call addgame(" 19.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 31 / Gruppe H : Spanien - Tunesien ",""," Stuttgart ") Call addgame(" 19.06.2006 "," 18:00:00 CEDT "," 19:45:00 CEDT "," Spiel 32 / Gruppe H : Saudi-Arabien - Ukraine ",""," Hamburg ") Call addgame(" 20.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 33 / Gruppe A : Ecuador - Deutschland ",""," Berlin ") Call addgame(" 20.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 34 / Gruppe A : Costa Rica - Polen ",""," Hannover ") Call addgame(" 20.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 35 / Gruppe B : Schweden - England ",""," Köln ") Call addgame(" 20.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 36 / Gruppe B : Paraguay - Trinidad&T. ",""," Kaiserslautern ") Call addgame(" 21.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 37 / Gruppe C : Niederlande - Argentinien ",""," Frankfurt ") Call addgame(" 21.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 38 / Gruppe C : Elfenbeinküste - Serbien&M. ",""," München ") Call addgame(" 21.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 39 / Gruppe D : Portugal - Mexiko ",""," Gelsenkirchen ") Call addgame(" 21.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 40 / Gruppe D : Iran - Angola ",""," Leipzig ") Call addgame(" 22.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 41 / Gruppe E : Tschechien - Italien ",""," Hamburg ") Call addgame(" 22.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 42 / Gruppe E : Ghana - USA ",""," Nürnberg ") Call addgame(" 22.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 43 / Gruppe F : Japan - Brasilien ",""," Dortmund ") Call addgame(" 22.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 44 / Gruppe F : Kroatien - Australien ",""," Stuttgart ") Call addgame(" 23.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 45 / Gruppe G : Togo - Frankreich ",""," Köln ") Call addgame(" 23.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 46 / Gruppe G : Schweiz - Südkorea ",""," Hannover ") Call addgame(" 23.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 47 / Gruppe H : Saudi-Arabien - Spanien ",""," Kaiserslautern ") Call addgame(" 23.06.2006 "," 16:00:00 CEDT "," 17:45:00 CEDT "," Spiel 48 / Gruppe H : Ukraine - Tunesien ",""," Berlin ") Call addgame(" 24.06.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 49 / Sieger Gruppe A - Zweiter Gruppe B ",""," München ") Call addgame(" 24.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 50 / Sieger Gruppe C - Zweiter Gruppe D ",""," Leipzig ") Call addgame(" 25.06.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 51 / Sieger Gruppe B - Zweiter Gruppe A ",""," Stuttgart ") Call addgame(" 25.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 52 / Sieger Gruppe D - Zweiter Gruppe C ",""," Nürnberg ") Call addgame(" 26.06.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 53 / Sieger Gruppe E - Zweiter Gruppe F ",""," Kaiserslautern ") Call addgame(" 26.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 54 / Sieger Gruppe G - Zweiter Gruppe H ",""," Köln ") Call addgame(" 27.06.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 55 / Sieger Gruppe F - Zweiter Gruppe E ",""," Dortmund ") Call addgame(" 27.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 56 / Sieger Gruppe H - Zweiter Gruppe G ",""," Hannover ") Call addgame(" 30.06.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 57 / Sieger Spiel 49 - Sieger Spiel 50 ",""," Berlin ") Call addgame(" 30.06.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 58 / Sieger Spiel 53 - Sieger Spiel 54 ",""," Hamburg ") Call addgame(" 01.07.2006 "," 17:00:00 CEDT "," 18:45:00 CEDT "," Spiel 59 / Sieger Spiel 55 - Sieger Spiel 56 ",""," Gelsenkirchen ") Call addgame(" 01.07.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 60 / Sieger Spiel 51 - Sieger Spiel 52 ",""," Frankfurt ") Call addgame(" 04.07.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 61 / Sieger Spiel 57 - Sieger Spiel 58 ",""," Dortmund ") Call addgame(" 05.07.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 62 / Sieger Spiel 59 - Sieger Spiel 60 ",""," München ") Call addgame(" 08.07.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 63 / Verlierer Spiel 61 - Verlierer Spiel 62 ",""," Stuttgart ") Call addgame(" 09.07.2006 "," 21:00:00 CEDT "," 22:45:00 CEDT "," Spiel 64 / Sieger Spiel 61 - Sieger Spiel 62 ",""," Berlin ") Beep Messagebox "Die Spieltage für die WM 2006 wurden in Ihren Kalender eingetragen." & Chr(10) & Chr(10) &_ "Bitte diese Funktion nicht noch einmal aufrufen, da sonst die Spieltage doppelt eingetragen werden!", 64, boxtitelEnd Sub
addgame:
Code
Sub addgame(strdate As String, strdatestart As String,strdateend As String, strsubject As String, BookFreeTime As String, Location As String)
Dim dt1 As NotesDateTime
Dim dt2 As NotesDateTime
Dim dt3 As NotesDateTime
Dim dt4 As NotesDateTime
Dim doc As NotesDocument
Set doc = New NotesDocument(db)
Set dt1 = New NotesDateTime(strdate &" " & strdatestart)
Set dt2 = New NotesDateTime(strdate &" " & strdateend)
Set dt3 = New NotesDateTime(strdatestart)
Set dt4 = New NotesDateTime(strdateend)
doc.Subject = strsubject
doc.Form = "Appointment"
doc.AppointmentType = "0"
Set doc.CalendarDateTime = dt1
Set doc.StartDateTime = dt1
Set doc.StartDate = dt1
Set doc.StartTime = dt3
Set doc.EndTime = dt4
doc.CHAIR = session.UserName
doc.Duration = 1
Set doc.EndDateTime = dt2
doc.From = session.UserName
doc.ExcludefromView = "D"
doc.ORGTABLE = "C0"
doc.Broadcast = ""
doc.Location=Location
doc.Categories = ""
Call doc.AppendItemValue("_ViewIcon", 70)
doc.BookFreetime = BookFreeTime
Call doc.AppendItemValue("$BusyName", session.UserName)
Call doc.AppendItemValue("$BusyPriority", "1")
Call doc.AppendItemValue("$NoPurge", dt2)
Call doc.AppendItemValue("$PublicAccess", "1")
doc.save True, True
Print strsubject & " wurde in Ihren Kalender eingetragen."
End Sub
Alles anzeigen
Button getestet und für gut befunden
Gruß,
Aspi