|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
November 18th 07, 08:34 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Getting the date in Calendar View
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? 
|
| Ads |
|
#2
November 19th 07, 08:29 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting the date in Calendar View
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: 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?
|
|
#3
November 19th 07, 08:09 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting the date in Calendar View
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 "Michael Bauer [MVP - Outlook]" wrote: 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: 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?
|
|
#4
November 19th 07, 09:44 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting the date in Calendar View
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 "BremUser" wrote in message ... 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 "Michael Bauer [MVP - Outlook]" wrote: Create a new AppointmentItem by code, don't call its Save method but read its start date. Am Sun, 18 Nov 2007 11:34:00 -0800 schrieb BremUser: 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?
|
|
#5
November 19th 07, 10:21 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting the date in Calendar View
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]" wrote: 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 "BremUser" wrote in message ... 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 "Michael Bauer [MVP - Outlook]" wrote: Create a new AppointmentItem by code, don't call its Save method but read its start date. Am Sun, 18 Nov 2007 11:34:00 -0800 schrieb BremUser: 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?
|
|
#6
November 19th 07, 10:33 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Getting the date in Calendar View
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 "BremUser" wrote in message ... 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]" wrote: Instead of CreateItem, call the New command from the menu/toolbar. See http://www.outlookcode.com/codedetail.aspx?id=616 "BremUser" wrote in message ... 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 "Michael Bauer [MVP - Outlook]" wrote: Create a new AppointmentItem by code, don't call its Save method but read its start date. Am Sun, 18 Nov 2007 11:34:00 -0800 schrieb BremUser: 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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| View completed tasks by calendar date | Len Schneider | Outlook - Calandaring | 3 | October 24th 07 07:11 PM |
| How to display the calendar in the month view at the current date | Joyce R | Outlook - Calandaring | 2 | May 25th 07 09:03 PM |
| Calendar view start date | Luke Chalmers | Outlook - Calandaring | 0 | January 31st 07 12:52 PM |
| I want calendar to display with today's date at top in month view | Ronnie | Outlook - General Queries | 1 | December 1st 06 03:02 AM |
| How do I show date navigator in my calendar view | Joy_McDerment | Outlook - Calandaring | 5 | July 13th 06 04:48 AM |
Linear Mode
