69 |
How do I encode data as ICalendar format
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content With .Components.Add("VCALENDAR") .Properties.Add("VERSION","2.1").Parameters.Add "UNICODE",ICalendar1.toICalendar(True,exPropertyTypeBoolean) .Properties.Add "TEXT","This is just a bit of text to be encoded." .Properties.Add "BINARY",ICalendar1.toICalendar("This is just a bit of text to be encoded.",exPropertyTypeBinary) With .Components.Add("VEVENT") .Properties.Add "DTSTART",#1/1/2001# .Properties.Add "DTEND",#1/2/2001 10:00:00 AM# End With End With End With Debug.Print( .Save ) End With |
68 |
How do I get the occurrences between giving start/end margins
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( "AsArray: " ) Debug.Print( .RecurRange("DTSTART=19970310;FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3",#1/1/2001#,#1/1/2002#) ) Debug.Print( "AsString: " ) Debug.Print( .RecurRangeAsString("DTSTART=19970310;FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3",#1/1/2001#,#1/1/2002#) ) End With |
67 |
How do I get the value of specified part in the recurrence expression
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( "FREQ: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurFREQ) ) Debug.Print( "DTSTART: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurDTSTART) ) Debug.Print( "UNTIL: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurUNTIL) ) Debug.Print( "COUNT: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurCOUNT) ) Debug.Print( "INTERVAL: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurINTERVAL) ) Debug.Print( "WKST: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurWKST) ) Debug.Print( "BYDAY: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYDAY) ) Debug.Print( "BYMONTHDAY: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYMONTHDAY) ) Debug.Print( "BYYEARDAY: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYYEARDAY) ) Debug.Print( "BYWEEKNO: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYWEEKNO) ) Debug.Print( "BYMONTH: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYMONTH) ) Debug.Print( "BYSETPOS: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYSETPOS) ) Debug.Print( "BYHOUR: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYHOUR) ) Debug.Print( "BYMINUTE: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYMINUTE) ) Debug.Print( "BYSECOND: " ) Debug.Print( .RecurPartValue("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",exRecurBYSECOND) ) End With |
66 |
How do I check if the recurrence expression is syntactically correct (method 2)
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( "1.A) SyntaxError: " ) Debug.Print( .RecurPartValue("DTSTART=20151205;FREQ=DAILY;BYDAY=MO",exRecurSyntaxError) ) Debug.Print( "1.B) SyntaxErrorInfo: " ) Debug.Print( .RecurPartValue("DTSTART=20151205;FREQ=DAILY;BYDAY=MO",exRecurSyntaxErrorInfo) ) Debug.Print( "2.A) SyntaxError: " ) Debug.Print( .RecurPartValue("FREQ=DAILY;BYDAY=MO",exRecurSyntaxError) ) Debug.Print( "2.B) SyntaxErrorInfo: " ) Debug.Print( .RecurPartValue("FREQ=DAILY;BYDAY=MO",exRecurSyntaxErrorInfo) ) End With |
65 |
How do I check if the recurrence expression is syntactically correct (method 1)
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( "1. If negative, the expression is incorrect" ) Debug.Print( .RecurCheck("DTSTART=20151205;FREQ=DAILY;BYDAY=MO",#12/5/2015#) ) Debug.Print( "2. If negative, the expression is incorrect" ) Debug.Print( .RecurCheck("junk",#1/1/2001#) ) End With |
64 |
How do I check if a specified date match the giving recurrence
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( #12/5/2015# ) Debug.Print( .RecurCheck("DTSTART=20151205;FREQ=DAILY;BYDAY=MO",#12/5/2015#) ) Debug.Print( #12/7/2015# ) Debug.Print( .RecurCheck("DTSTART=20151205;FREQ=DAILY;BYDAY=MO",#12/7/2015#) ) End With |
63 |
Recur: The 2nd to last weekday of the month
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970929;FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-2",12) ) End With |
62 |
Recur: The 3rd instance into the month of one of Tuesday, Wednesday or Thursday, for the next 3 months
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970904;FREQ=MONTHLY;COUNT=3;BYDAY=TU,WE,TH;BYSETPOS=3",12) ) End With |
61 |
Recur: The last work day of the month
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970805;FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-1",12) ) End With |
60 |
Recur: An example where the days generated makes a difference because of WKST (Sample 2)
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU",12) ) End With |
59 |
Recur: An example where the days generated makes a difference because of WKST (Sample 1)
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970805T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=MO",12) ) End With |
58 |
Recur: Every 20 minutes from 9:00 AM to 4:40 PM every day
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16;BYMINUTE=0,20,40",12) ) End With |
57 |
Recur: Every hour and a half for 4 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=MINUTELY;INTERVAL=90;COUNT=4",12) ) End With |
56 |
Recur: Every 15 minutes for 6 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=MINUTELY;INTERVAL=15;COUNT=6",12) ) End With |
55 |
Recur: Every 3 hours from 9:00 AM to 5:00 PM on a specific day
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=HOURLY;INTERVAL=3;UNTIL=19970902T170000Z",12) ) End With |
54 |
Recur: Every four years, the first Tuesday after a Monday in November, forever (U.S. Presidential Election day)
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19961105T090000;FREQ=YEARLY;INTERVAL=4;BYMONTH=11;BYDAY=TU;BYMONTHDAY=2,3,4,5,6,7,8",12) ) End With |
53 |
Recur: The first Saturday that follows the first Sunday of the month, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970913T090000;FREQ=MONTHLY;BYDAY=SA;BYMONTHDAY=7,8,9,10,11,12,13",12) ) End With |
52 |
Recur: Every Friday the 13th, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=MONTHLY;BYDAY=FR;BYMONTHDAY=13",12) ) End With |
51 |
Recur: Every Thursday, but only during June, July, and August, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970605T090000;FREQ=YEARLY;BYDAY=TH;BYMONTH=6,7,8",12) ) End With |
50 |
Recur: Every Thursday in March, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970313T090000;FREQ=YEARLY;BYMONTH=3;BYDAY=TH",12) ) End With |
49 |
Recur: Monday of week number 20 (where the default start of the week is Monday), forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970512T090000;FREQ=YEARLY;BYWEEKNO=20;BYDAY=MO",12) ) End With |
48 |
Recur: Every 20th Monday of the year, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970101T090000;FREQ=YEARLY;BYDAY=20MO",12) ) End With |
47 |
Recur: Every 3rd year on the 1st, 100th and 200th day for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970101T090000;FREQ=YEARLY;INTERVAL=3;COUNT=10;BYYEARDAY=1,100,200",12) ) End With |
46 |
Recur: Every other year on January, February, and March for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970310T090000;FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3",12) ) End With |
45 |
Recur: Yearly in June and July for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970610T090000;FREQ=YEARLY;COUNT=10;BYMONTH=6,7",12) ) End With |
44 |
Recur: Every Tuesday, every other month
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=MONTHLY;INTERVAL=2;BYDAY=TU",12) ) End With |
43 |
Recur: Every 18 months on the 10th thru 15th of the month for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970910T090000;FREQ=MONTHLY;INTERVAL=18;COUNT=10;BYMONTHDAY=10,11,12,13,14,15",12) ) End With |
42 |
Recur: Monthly on the first and last day of the month for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970930T090000;FREQ=MONTHLY;COUNT=10;BYMONTHDAY=1,-1",12) ) End With |
41 |
Recur: Monthly on the 2nd and 15th of the month for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=MONTHLY;COUNT=10;BYMONTHDAY=2,15",12) ) End With |
40 |
Recur: Monthly on the third to the last day of the month, forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970928T090000;FREQ=MONTHLY;BYMONTHDAY=-3",12) ) End With |
39 |
Recur: Monthly on the second to last Monday of the month for 6 months
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970922T090000;FREQ=MONTHLY;COUNT=6;BYDAY=-2MO",12) ) End With |
38 |
Recur: Every other month on the 1st and last Sunday of the month for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970907T090000;FREQ=MONTHLY;INTERVAL=2;COUNT=10;BYDAY=1SU,-1SU",12) ) End With |
37 |
Recur: Monthly on the 1st Friday until December 24, 1997
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970905T090000;FREQ=MONTHLY;UNTIL=19971224T000000Z;BYDAY=1FR",12) ) End With |
36 |
Recur: Monthly on the 1st Friday for ten occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970905T090000;FREQ=MONTHLY;COUNT=10;BYDAY=1FR",12) ) End With |
35 |
Recur: Every other week on Tuesday and Thursday, for 8 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=WEEKLY;INTERVAL=2;COUNT=8;WKST=SU;BYDAY=TU,TH",12) ) End With |
34 |
Recur: Every other week on Monday, Wednesday and Friday until December 24, 1997, but starting on Tuesday, September 2, 1997
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=WEEKLY;INTERVAL=2;UNTIL=19971224T000000Z;WKST=SU;BYDAY=MO,WE,FR",12) ) End With |
33 |
Recur: Weekly on Tuesday and Thursday for 5 weeks
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=WEEKLY;UNTIL=19971007T000000Z;WKST=SU;BYDAY=TU,TH",12) ) End With |
32 |
Recur: Weekly on Tuesday and Thursday for 5 weeks
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=WEEKLY;COUNT=10;WKST=SU;BYDAY=TU,TH",12) ) End With |
31 |
Recur: Every other day - forever
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=DAILY;INTERVAL=2",12) ) End With |
30 |
Recur: Daily until December 24, 1997
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=DAILY;UNTIL=19971224T000000Z",12) ) End With |
29 |
Recur: Daily for 10 occurrences
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( .RecurAllAsString("DTSTART=19970902T090000;FREQ=DAILY;COUNT=10",12) ) End With |
28 |
How can I add a property of UTC offset type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "UTCOffset","+0100" End With Debug.Print( .Save ) End With |
27 |
How can I add a property of URI type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "URI","http://www.exontrol.com" End With Debug.Print( .Save ) End With |
26 |
How can I add a property of time type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Time1",#12/30/1899 0:00:00 PM# .Properties.Add "Time2",ICalendar1.toICalendar(0.5,exPropertyTypeTime) With .Properties.Add("Time3") .Value = 0.5 .Type = exPropertyTypeTime End With End With Debug.Print( .Save ) End With |
25 |
How can I add a property of text/string type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Text1","A1" .Properties.Add "Text2",ICalendar1.toICalendar("A1",exPropertyTypeText) With .Properties.Add("Text3") .Value = "A1" .Type = exPropertyTypeText End With End With Debug.Print( .Save ) End With |
24 |
How can I find properties of recurence type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Recur","FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=SA,SU" End With Set p = .Root.Properties.Item("Recur") i = .toICalendar(p.Value,p.GuessType) Debug.Print( "icalendar:" ) Debug.Print( i ) Debug.Print( "all:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"") ) Debug.Print( "FREQ:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"FREQ") ) Debug.Print( "UNTIL:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"UNTIL") ) Debug.Print( "COUNT:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"COUNT") ) Debug.Print( "INTERVAL:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"INTERVAL") ) Debug.Print( "BYSECOND:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYSECOND") ) Debug.Print( "BYMINUTE:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYMINUTE") ) Debug.Print( "BYHOUR:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYHOUR") ) Debug.Print( "BYDAY:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYDAY") ) Debug.Print( "BYMONTHDAY:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYMONTHDAY") ) Debug.Print( "BYYEARDAY:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYYEARDAY") ) Debug.Print( "BYWEEKNO:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYWEEKNO") ) Debug.Print( "BYMONTH:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYMONTH") ) Debug.Print( "BYSETPOS:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"BYSETPOS") ) Debug.Print( "WKST:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"WKST") ) End With |
23 |
How can I add a property of recurrence type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Recur","FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU" End With Debug.Print( .Save ) End With |
22 |
How can I find the duration in weeks, days, hours, minutes, seconds from a property of duration type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Period",ICalendar1.valuesToICalendar("Start=#1/1/2001#;Duration=1",exPropertyTypePeriod) End With Set p = .Root.Properties.Item("Period") i = .toICalendar(p.Value,p.GuessType) Debug.Print( "icalendar:" ) Debug.Print( i ) Debug.Print( "all:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"") ) Debug.Print( "start:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"Start") ) Debug.Print( "end:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"End") ) Debug.Print( "duration:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"Duration") ) Debug.Print( "weeks:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"W") ) Debug.Print( "days:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"D") ) Debug.Print( "hour:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"H") ) Debug.Print( "min:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"M") ) Debug.Print( "sec:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"S") ) End With |
21 |
How can I add a property of period type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Period1",ICalendar1.valuesToICalendar("Start=#1/1/2001#;Duration=1",exPropertyTypePeriod) .Properties.Add "Period2",ICalendar1.valuesToICalendar("Start=#1/1/2001#;End=#1/2/2001#",exPropertyTypePeriod) .Properties.Add "Period3",ICalendar1.valuesToICalendar("Duration=1;End=#1/2/2001#",exPropertyTypePeriod) End With Debug.Print( .Save ) End With |
20 |
How can I add a property of integer type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Integer1",1 .Properties.Add "Integer2",ICalendar1.toICalendar(1,exPropertyTypeInteger) With .Properties.Add("Integer3") .Value = 1 .Type = exPropertyTypeInteger End With End With Debug.Print( .Save ) End With |
19 |
How can I add a property of float type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Float1",1.5 .Properties.Add "Float2",ICalendar1.toICalendar(1.5,exPropertyTypeFloat) With .Properties.Add("Float3") .Value = 1.5 .Type = exPropertyTypeFloat End With End With Debug.Print( .Save ) End With |
18 |
How do I get the type of the property
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Duration1",ICalendar1.toICalendar(2.5,exPropertyTypeDuration) With .Properties.Add("Duration2") .Value = 2.5 .Type = exPropertyTypeDuration End With End With With .Root.Properties.Item("Duration1") Debug.Print( .Name ) Debug.Print( "Guess" ) Debug.Print( .GuessType ) Debug.Print( .Name ) Debug.Print( "Type" ) Debug.Print( .Type ) End With With .Root.Properties.Item("Duration2") Debug.Print( .Name ) Debug.Print( "Guess" ) Debug.Print( .GuessType ) Debug.Print( .Name ) Debug.Print( "Type" ) Debug.Print( .Type ) End With End With |
17 |
How can I get values of the duration iCalendar format
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 Debug.Print( "all:" ) Debug.Print( .valuesFromICalendar("P1D",exPropertyTypeDuration,"") ) Debug.Print( "duration:" ) Debug.Print( .valuesFromICalendar("P1D",exPropertyTypeDuration,"Duration") ) End With |
16 |
How can I find the duration in weeks, days, hours, minutes, seconds from a property of duration type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Duration",ICalendar1.toICalendar(3.325,exPropertyTypeDuration) End With Set p = .Root.Properties.Item("Duration") i = .toICalendar(p.Value,p.GuessType) Debug.Print( "icalendar:" ) Debug.Print( i ) Debug.Print( "all:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"") ) Debug.Print( "duration:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"Duration") ) Debug.Print( "weeks:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"W") ) Debug.Print( "days:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"D") ) Debug.Print( "hour:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"H") ) Debug.Print( "min:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"M") ) Debug.Print( "sec:" ) Debug.Print( .valuesFromICalendar(i,p.GuessType,"S") ) End With |
15 |
How can I add a property of duration type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Duration1",ICalendar1.toICalendar(2.5,exPropertyTypeDuration) With .Properties.Add("Duration2") .Value = 2.5 .Type = exPropertyTypeDuration End With .Properties.Add "Duration3",ICalendar1.valuesToICalendar("D=2;H=12",exPropertyTypeDuration) End With Debug.Print( .Save ) End With |
14 |
How can I add a property of date-time type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "DateTime1",#1/1/2001 0:00:00 PM# .Properties.Add "DateTime2",ICalendar1.toICalendar(#1/1/2001#,exPropertyTypeDateTime) With .Properties.Add("DateTime3") .Value = #1/1/2001# .Type = exPropertyTypeDateTime End With End With Debug.Print( .Save ) End With |
13 |
How can I add a property of date type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Date1",#1/1/2001# .Properties.Add "Date2",ICalendar1.toICalendar(#1/1/2001#,exPropertyTypeDate) With .Properties.Add("Date3") .Value = #1/1/2001# .Type = exPropertyTypeDate End With End With Debug.Print( .Save ) End With |
12 |
How can I add a property of Calendar User Address type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "caladdress1","mailto:support@exontrol.com" .Properties.Add "caladdress2",ICalendar1.toICalendar("mailto:support@exontrol.com",exPropertyTypeCalAddress) With .Properties.Add("caladdress3") .Value = "mailto:support@exontrol.com" .Type = exPropertyTypeCalAddress End With End With Debug.Print( .Save ) End With |
11 |
How can I add a property of boolean type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Boolean1",True .Properties.Add "Boolean2",ICalendar1.toICalendar("TRUE",exPropertyTypeBoolean) With .Properties.Add("Boolean3") .Value = 0 .Type = exPropertyTypeBoolean End With End With Debug.Print( .Save ) End With |
10 |
How can I add a property of binary type
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") .Properties.Add "Binary1",ICalendar1.toICalendar("This is a bit of text converted to binary",exPropertyTypeBinary) With .Properties.Add("Binary2") .Value = "This is a bit of text converted to binary" .Type = exPropertyTypeBinary End With End With Debug.Print( .Save ) End With |
9 |
How can I access the root element of the iCalendar format
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 .Load "BEGIN:VCALENDAR\r\nVERSION:2.0\r\nEND:VCALENDAR" Debug.Print( .Root.Name ) Debug.Print( .Root.Properties.Item("Version").Value ) End With |
8 |
How can I get notified once the control loads a new component, property, when using Load or LoadFile methods
' AddComponent event - Occurs when a new component is added. Private Sub ICalendar1_AddComponent(ByVal NewComponent As EXICALENDARLibCtl.IComponent) With ICalendar1 Debug.Print( NewComponent ) End With End Sub ' AddProperty event - Occurs when a new property is added. Private Sub ICalendar1_AddProperty(ByVal NewPropery As EXICALENDARLibCtl.IProperty) With ICalendar1 Debug.Print( NewPropery ) End With End Sub Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 .FireEvents = True .Load "BEGIN:VCALENDAR\r\nVERSION:2.0\r\nEND:VCALENDAR" End With |
7 |
How can I add a property with parameters
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") With .Components.Add("VEVENT").Properties .Add("SUMMARY","Company Holiday Party").Parameters.Add "LANGUAGE","en-US" .Add "DATE",#1/1/2001# End With End With Debug.Print( .Save ) End With |
6 |
How can I load iCalendar from a string
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 .Load "BEGIN:VCALENDAR\r\nVERSION:2.0\r\nEND:VCALENDAR" Debug.Print( .Content.Components.Item(0).Name ) End With |
5 |
How can I add VEVENT objects
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") With .Properties .Add "Version","2.0" .Add "PRODID","-//hacksw/handcal//NONSGML v1.0//EN" End With With .Components.Add("VEVENT").Properties .Add "DTSTART",#1/1/2001# .Add "DTEND",#1/2/2001# .Add "SUMMARY","First Party" End With With .Components.Add("VEVENT").Properties .Add "DTSTART",#1/4/2001# .Add "DTEND",#1/5/2001# .Add "SUMMARY","Second Party" End With End With Debug.Print( .Save ) End With |
4 |
How can I save the control's content to iCalendar format, as a file
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") With .Properties .Add "Version","2.0" .Add "PRODID","-//hacksw/handcal//NONSGML v1.0//EN" End With With .Components.Add("VEVENT").Properties .Add "DTSTART",#1/1/2001# .Add "DTEND",#1/2/2001# .Add "SUMMARY","Bastille Day Party" End With End With .SaveFile "c:/temp/test.ical" End With |
3 |
How can I load the iCalendar format from a file
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 .LoadFile "c:/temp/test.ical" Debug.Print( .Content.Components.Item("VCALENDAR").Properties.Item("PRODID").Value ) End With |
2 |
How do I export the control's content to iCalendar format
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR") With .Properties .Add "Version","2.0" .Add "PRODID","-//hacksw/handcal//NONSGML v1.0//EN" End With With .Components.Add("VEVENT").Properties .Add "DTSTART",#1/1/2001# .Add "DTEND",#1/2/2001# .Add "SUMMARY","Bastille Day Party" End With End With Debug.Print( .Save ) End With |
1 |
How can I generate a VCALENDAR object
Set ICalendar1 = CreateObject("Exontrol.ICalendar.1") With ICalendar1 With .Content.Components.Add("VCALENDAR").Properties .Add "Version","2.0" .Add "PRODID","-//hacksw/handcal//NONSGML v1.0//EN" End With Debug.Print( .Save ) End With |