Getting the date in Calendar View

[Guest]

In Calendar view in Outlook 2007, I want to retreive the date of the day I
selected. When I double-click on a date the appointment-form comes up with
the right date filled in. What I want to do is selecting a day and clicking a
toolbar-button with a vba-script behind it, that uses that day for further
handling.

Can someone help me please?

 

[Michael Bauer [MVP - Outlook]]

Create a new AppointmentItem by code, don't call its Save method but read
its start date.

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Color Categories & Ensure that Every Item Gets Categorized:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Sun, 18 Nov 2007 11:34:00 -0800 schrieb BremUser:

 

[Guest]

Michael,

Thank you for you reply.
But it doesn't work.
When I create a new appointment with:
loAppointment = Application.CreateItem(olAppointmentItem)
I always get todays date in the start date.

The Calendar View is of type Day/Week/Month in the Month view.
When a day is highlighted, I want to know what that day is in VBA. Isn't
there any property field in the CalendarView object, which I missed?

Regards
Ben
Technology Consultant Microsoft Technologies

 

[Sue Mosher [MVP-Outlook]]

Instead of CreateItem, call the New command from the menu/toolbar. See http://www.outlookcode.com/codedetail.aspx?id=616

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Guest]

Sue,

Thank you for your reply.
It indeed functions.
A pitty that there is not a propertie present in the CalendarView object
representing the start date and end date of the selected dates.
But nevertheless, for now this solution solved my problem.

Regards and thank you again,

Ben
Technology Consultant Microsoft Technologies

 

[Sue Mosher [MVP-Outlook]]

I agree. Even though the CalendarView object in Outlook 2007 has a DisplayedDates property, it's broken in RTM and doesn't tell you anything about the selected date/time (if any).

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54